topic Re: Filter pane based KPI in App Development

Filter pane based KPI

Kaushik2020 — Thu, 13 Oct 2022 10:01:26 GMT

Hi all,

I have 3 KPI: High Low and median.
2 filter panes : Category and Year.
I have 3 values in category filter pane: Switches, Router and Access points

When user select Router from category filter pane - the KPI should show High, Low and median for the selection (Router in this case)

But, when the user select any Year from the year filter pane, the KPI should not refresh.
Data in KPI should show Highest price for the category.

Eg:-
Router--> 2021. High =35.22 and LOW=3.02

Re: Filter pane based KPI

KatjaK — Thu, 13 Oct 2022 15:22:34 GMT

Hi @Kaushik2020 ,

please try this idea:

If you have your KPI 'High' defined as follows: MAX(myMeasureFieldName)

Example 1
Introducing a {1} within the MAX function will make this calculation ignore any selection made: MAX({1} myMeasureField)

However, this calculation will also ignore the selection of your category.

So the formula of the KPI is adapted in a way, that it ignores any selection except the selection of a category: MAX({1<Category=$::Category>} myMeasureFieldName)

Example 2:

If you would like to ignore only the selection of the Year, and keep all other selections (Category, further selections, that you have on your board), then the formula looks like this: MAX({<Year=>} myMeasureFieldName)

I hope, this solves your problem!

Re: Filter pane based KPI

Kaushik2020 — Thu, 20 Oct 2022 10:20:21 GMT

thanks a lot. solution in example 1 worked for my requirement. 🙂

Re: Filter pane based KPI

Kaushik2020 — Thu, 20 Oct 2022 10:23:20 GMT

Also if i wish to add Category and Year, then how we can write in the same example ?

Re: Filter pane based KPI

KatjaK — Thu, 20 Oct 2022 10:48:48 GMT

If you wish to ignore all selection except Category and Year, then add the same expression in the set analysis block for both fields:

MAX({1<Category=$::Category, Year=$::Year>} myMeasureFieldName)

Re: Filter pane based KPI

Kaushik2020 — Fri, 11 Nov 2022 07:15:57 GMT

Can I add 3 filter petameters eg: MAX({1<Category=$::Category, Year=$::Year,(3rd filter parameter)>} myMeasureFieldName) ?

Re: Filter pane based KPI

KatjaK — Fri, 11 Nov 2022 07:17:44 GMT

Yes, you can add as many parameters as you wish.