Hey all, I've been lurking on the forums and already got a lot of helpful insight from all the answers you provided to other's questions. However my current issue I could not find a working solution to.
I want to compare the Earnings (E) of customers who have adapted our new solution. In my data set I have rows for each of the transactions and an indicator if it was generated by the New Product (NP) or the Original Product (OP).
I have all sorts of calculations and tables in place that compare the (E) generated by the (NP) and the (OP), but what I want to do is compare the overall (E) since implementing the (NP). So what I want to do is somehow come up with a calculated field for Earnings since implementing the new product and Earnings before implementing the new product. The date of implementation will be different for each of the customers.
I have a calculated field called NP transaction date:
IF [New Product]=1 then
What I was trying to do is define the Earningsperiod with a calculation like this:
IF MIN([NP transaction date]) < [Transaction Date] then
This of course results in the aggregate vs non-aggregate battle but I can't figure out a way to fix that.
Adding ATTR to the transaction date doesn't work:
IF MIN([NP transaction date]) < ATTR([Transaction Date]) then
if I try to then show the number in a table (so that it would list the earnings from each of the customers in that period) the table just stays empty.
Can any of you help me with how you would go about this or just point me in the right direction so I can further research a solution?
I really appreciate any input!
Example of what the data looks like (lot more rows and columns but I think this is all that is relevant to the question).
|Customer||Transaction Date||Earnings||New Product? (1= NP, 0=OP)|
P.S.: I do not have access to the desktop version of tableau, only the online one, so not sure if I'm able to attach an example worksheet.