topic Re: Display values in KPI only if there's a filter selection in App Development

Display values in KPI only if there's a filter selection

lailarhc — Tue, 30 Nov 2021 18:17:33 GMT

Hello.
I have a couple of KPIs and I want them to not show anything unless a particular dimension is selected.

Here's a image of my dashboard:

I want the KPIs in red to only display values if there's an employee or more selected. How do I do this?
I tried putting GetFieldSelection(Employee) and GetFieldSelection(Employee) = Employee on the Calculation Condition in the Data Handling section, but it doesn't work.

How can I achieve this?
Thank you in advance.

Re: Display values in KPI only if there's a filter selection

GaryGiles — Wed, 16 Jun 2021 12:31:51 GMT

Try using this in the KPI measure expression:

=if(GetFieldSelections([Employee])>0,count(Course),'')

Re: Display values in KPI only if there's a filter selection

lailarhc — Wed, 16 Jun 2021 12:55:49 GMT

It worked. Thank you 🙂