I have some financial data. Very simple, I have a posting date, a total, and a document type.
I have two different document types, ZP and ZR.
The logic works like this.
Example; I have one ZR record on 5/1/13 and that total is $1000. I have multiple ZP records on 5/2/13 and they total $1000.
In theory, when summing the ZP records from the following day of the ZR record, both totals should match.
In reality, I am seeing that the totals can match in 1 day, 2 days, 3 days, etc. It's not always a one day spread.
I am trying to show this in a visual.
I was trying to do something like this.
This would be my field listing;
Post Date, Post Date + Day spread as defined by a parameter, ZR record total for Post Date, ZP record total for Post Date + Spread.
That's what I am trying to do but I can't get it to work. Can I not get all of this information into one line of a view?
Thanks a million for the help.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...