
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