Dynamic KPI Comparison

Question & Answer
,
1

Hi,
I have this KPI:

image
image255×150 4.86 KB

And this parameter:
image

I want the comparison to be dynamic (when I click on Month it will be a monthly comparison, when I click on the Quarter it will be a quarter comparison)
How can I do it?

Thanks

2

Hi @InbalK,
There are 2 ways you could achieve this outcome:

  1. Use the free-form layout, create 2 identical KPI’s, one that runs a monthly comparison and one that runs the quarterly, then set up a rule to show the correct visual based on your parameter selection.

  2. Create an ifelse statement that does the correct calculation based on the parameter selection. Then use this ifelse calculation as your KPI field instead.
    For example,

ifelse(
   ${GroupBy} = 'Month', (Monthly Calculation),
   ${GroupBy} = 'Quarter', (Quarterly Calculation),
   NULL)

Let me know if you have any additional questions

1 Like