Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
i want to calculate the QoQ and YoY like below attached screen shot in pivot table.
and the data is attached it is coming from db directly.
how can i do this?
Hi Sony,
Modified the graph but didnt understand the second graph explanation.
Maybe you can try and get it from the info and graphs that are already in the app an create the visualization you need.
Sony,
the comparison must be implemented betewen the current year and the previous or between a selected year and the previous of the selected?
For the Y/Y field you could use something like this (in the load script I extracted the YEAR from the quarter)
(Sum({<Year = {'$(=Max(Year))'}>} [Value])-Sum({<Year = {'$(=Max(Year)-1)'}>} [Value]))/Sum({<Year = {'$(=Max(Year)-1)'}>} [Value]))
that compare the year selected and the previous, if you want to compare the current and the previous you have to replace Max(Year) with Year(Today()).
For the Q/Q the formula is similar but more info are needed: what do you want to compare? This quarter with the previous? A selected quarter with the previous?
If with the current, you need to create a variable in the script.
LET vThisQuarter = 'Q' & ceil(month(Today())/3);
and then use it in the set analysis.
But I think that more information are needed (about the totals in the png too).
kind regards,
S.
for Y/Y - for the selected year should be same for previous year
for Q/Q - for example
so if Sep 27 is week no 39 for the year and week no 9 for the quarter, it has to be compared with week no 39 of previous year and week no 9 for the prev quarter
for QOQ how can i include this in set LET vThisQuarter = 'Q' & ceil(month(Today())/3);?
Hi Frank Hartmann any solution for this?
Hi Sony,
See the attached QVW for a solution.
Felip.
thank you so much sir
. i m checking on this --
one doubt QoQ and YoY the values is showing more than 100% like 209% 430% like that... is that correct?
Thats dependant on the data you have on the spreadsheet.
As i've seen, your data is having that data and gives the correct value:
see the following:
Check the file to see if the values are correct and once they're ok, the app will show the appropriate data.
thanks for the clarification..
i have attached the updated qvw.. in this i have implemented document on open trigger
it should select the current quarter and next 3 quarters.
means 2018Q3 current quarter
2018Q3
2019Q1
2019Q2
2019Q3 this is one table
and one more table with same QoQ and YoY --
it should having the selection for
2018Q3
2019Q1
2019Q2
2019Q3 and above 2019Q3 ,2019Q4 ,2020Q1.... so on how can i include this in other table?
What you could do is this:
Based on the selections, you get the values from the minimum value selected to all the quarters from that point on, and then limit the graph to 4 first values for fiscal period.
See the attached QVW.