+8Hi,
I’m wondering if it’s possible to create Year Over Year calculations that apply to Months, Quarters, and Years.
It works fine at the Total Year Level:
But it does not allow you to expand “Years” and view the corresponding YoY calc for quarters:
Is there a workaround for this?
Best answer by Gigi
Hi Tgilbert!
Thank you for the question.
It may help to explain that analysis “Calculated Items” are display-level calculations. They often work at the current level you’re viewing (e.g.Year total) but don’t behave consistently when you expand a time hierarchy (Year > Quarter > Month).
Instead of a Calculated Item, build YoY as a model metric so it works at every time level automatically.
Start from your base metric
Example: Revenue (or any metric you want to compare year-over-year)
Now when you expand Years > Quarters > Months, the YoY should stay consistent because it’s computed from the model, not the view.
I hope this helps!
Please check out the following articles which may be of use:
Hi Tgilbert!
Thank you for the question.
It may help to explain that analysis “Calculated Items” are display-level calculations. They often work at the current level you’re viewing (e.g.Year total) but don’t behave consistently when you expand a time hierarchy (Year > Quarter > Month).
Instead of a Calculated Item, build YoY as a model metric so it works at every time level automatically.
Start from your base metric
Example: Revenue (or any metric you want to compare year-over-year)
Now when you expand Years > Quarters > Months, the YoY should stay consistent because it’s computed from the model, not the view.
I hope this helps!
Please check out the following articles which may be of use:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
