Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Beginner 101 questions: How do I filter a KPI to just show the Current Year Data? There is a Time Dimension with CY & PY for Current & Prior Year - see bar chart below. When I select the measure for the KPI view it is summing both the CY & PY. How do I set up to only sum the Current Year in the KPI then show a 2nd measure for the % change of CY Conversions / PY Conversions?
Thank you!
I think that u have a dimension "Time" containing 2 Values? CY and LY?
then in ur KPI, for CY
change ur measure
from:
sum(Measure)
to
for current
sum({<Time={'CY'}>}Measure)
for last
sum({<Time={'LY'}>}Measure)
can you explain a little bit more?
If your CY and PY are flags in your calendar,then
Current
Sum({<CY={1}>} Conversions)
Previous
Sum({<PY={1}>} Conversions)
I think that u have a dimension "Time" containing 2 Values? CY and LY?
then in ur KPI, for CY
change ur measure
from:
sum(Measure)
to
for current
sum({<Time={'CY'}>}Measure)
for last
sum({<Time={'LY'}>}Measure)
Thanks Omar. That did it. Appreciate the 101 lesson.