
1. Re: How to calculate QoQ in Table Calculation
Hari Ankem Jun 13, 2018 11:55 AM (in response to Helen Wang)2 of 2 people found this helpful 
2. Re: How to calculate QoQ in Table Calculation
Helen Wang Jun 13, 2018 12:42 PM (in response to Hari Ankem)Thank you so much!
I have a follow up question on how to color them:
How to color two quick table calculation with the same standard
I have tried to use the color method you taught me before but I do not know how to index two metrcis in one measure:
if [QoQ%]>0.8 or [QoQ%]< 0.8 then 'Red'
elseif [QoQ%]>0.2 or [QoQ%]< 0.2 then 'Purple'
else "Blue"
END
I have two QoQ now.

3. Re: How to calculate QoQ in Table Calculation
Hari Ankem Jun 13, 2018 1:56 PM (in response to Helen Wang)1 of 1 people found this helpfulWhen you state you have 2 QoQs, do you mean the way you are using it above, or 2 different QoQs altogether? If it's the same variable being used twice, what you have written above is correct and should be used the same way.

4. Re: How to calculate QoQ in Table Calculation
Helen Wang Jun 13, 2018 1:59 PM (in response to Hari Ankem)The way I am using it above:
I have one QoQ (compared against the previous quarter) on the second line
and another QoQ (compared against the one in previous year) on the third line.
It is different QoQ (different table calculation). But I want to create a color measure to color those above >80% red.
Thanks,
Helen

5. Re: How to calculate QoQ in Table Calculation
Hari Ankem Jun 13, 2018 2:17 PM (in response to Helen Wang)1 of 1 people found this helpfulOK. What you should first do in this case is that you need to have different names for the different calculations. So, you should first drag the calculation from the Measure Values to the Measures section. This will enable you to give a name for the calculated field. Repeat for the second method of calculation too. In the image below, the 2 calculated fields for me now are "QoQ" and "QoQ (YoY)". You should be able to see them in the Measures section on the left. I am then using it in the color calculation as shown below.

6. Re: How to calculate QoQ in Table Calculation
Helen Wang Jun 15, 2018 9:01 AM (in response to Hari Ankem)HI Hari,
If you have time, could you please help me with one question?
How to index time series data: combine past actual and future forecast from different measure names
Thanks!

7. Re: How to calculate QoQ in Table Calculation
Hari Ankem Jun 15, 2018 9:50 AM (in response to Helen Wang)1 of 1 people found this helpfulIt looks like that the question has already been answered.

8. Re: How to calculate QoQ in Table Calculation
Helen Wang Jun 15, 2018 10:17 AM (in response to Hari Ankem)Simon didn't provide the answer I want. Could you please help me take a look? Thanks

9. Re: How to calculate QoQ in Table Calculation
Helen Wang Jun 15, 2018 10:32 AM (in response to Hari Ankem)How to index time series data: combine past actual and future forecast from different measure names
Hi Hari, the answer is not what I want. If you have time, could you please help me take a look?
Thanks,
Helen

10. Re: How to calculate QoQ in Table Calculation
Rajesh Agarwal Oct 20, 2018 4:04 PM (in response to Hari Ankem)Hi Hari
I need to create a dashboard which has data for 2 weeks (it is rolling 2 weeks; previous week and current week) and KPIs as measures. I need to show Delta between 2 weeks. There is a filter for week, means user can select week 1 and week 3 and see the delta. By default it will current week and previous week.
There will be a filter for KPI too.
Please help me do this. I have posted this on Tableau Community as well.
Attached is the sample workbook.

KPI.twbx 19.7 KB


11. Re: How to calculate QoQ in Table Calculation
Hari Ankem Oct 22, 2018 8:16 AM (in response to Rajesh Agarwal)Have you tried the quick table calculation to do the difference? Or would something like this work?
See the attached workbook to see if it helps.

KPI.twbx 69.9 KB
