
1. Re: Calculating the differnce of a measure across a dimension
Deepak Rai Jun 21, 2018 3:09 PM (in response to Laura FlatowEisenhauer)Hi Laura,
We need the workbook or data to Help you.
Thanks
Deepak

2. Re: Calculating the differnce of a measure across a dimension
Jim Dehner Jun 21, 2018 3:14 PM (in response to Laura FlatowEisenhauer)Hi
see the attached
its easier to expain when you send us your twbx workbook 
but the superstore example will have to do
your instinct is correct you want to pivot the data  tableau and all other database oriented systems (like access) like data that is tall and narrow
the "columns" are measures and dimensions  dimensions categorize data Measures contain the actual values
so you want to end up with columns like movie titles, sample, and dates (for dimensions) and then you values as a single column form measures
then the table calculations are based on the table you create when you bring values to the viz
this is the diff WOW
computed across the table
this is the percent diff
you dont need to remember them just right click the measure and add a table calc
and select from the drop down
there are some formating things that could be applied to the table but this is the basic
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

diff wow.twbx 2.4 MB


3. Re: Calculating the differnce of a measure across a dimension
Laura FlatowEisenhauer Jun 22, 2018 9:07 AM (in response to Deepak Rai)My mistake, I thought I had uploaded the workbook.

calculate gain example.twbx 31.2 KB


4. Re: Calculating the differnce of a measure across a dimension
Laura FlatowEisenhauer Jun 22, 2018 12:33 PM (in response to Jim Dehner)Jim,
Thanks so much, this was very helpful. I was able to recerate your calculations into my dummy data set, but the percent change calculation still seems a bit off.
I attached my updated workbook (to the original message, I think). Did I implement this correctly?
Laura

5. Re: Calculating the differnce of a measure across a dimension
Jim Dehner Jun 22, 2018 1:06 PM (in response to Laura FlatowEisenhauer)1 of 1 people found this helpfulsee the attached
this is what it returns
the formulae are
and
each is calculated like this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

6. Re: Calculating the differnce of a measure across a dimension
Laura FlatowEisenhauer Jun 22, 2018 1:13 PM (in response to Jim Dehner)thanks! I guess I was missing a parenthesis in mine!
Cheers! Bonus points if you can get it into a bar chart that shows the sample group A stacked with the difference between the two, that will be my next exploration into visualizing my data sets
L

9. Re: Calculating the differnce of a measure across a dimension
Laura FlatowEisenhauer Jun 22, 2018 1:49 PM (in response to Laura FlatowEisenhauer)for clarity I suppose that should read: "increase in sample (BA)"

10. Re: Calculating the differnce of a measure across a dimension
Jim Dehner Jun 22, 2018 1:54 PM (in response to Laura FlatowEisenhauer)I see you went to Pencil perfect for that on visual
see the attached  it the best I can do on Friday afternoon
it returns this
calculate the difference as
Jim
Have a good weekend