topic How To Ignore all filters on Calculated KPI's in App Development

How To Ignore all filters on Calculated KPI's

jamiemcc — Wed, 21 Jul 2021 15:22:48 GMT

Hi Guys,

How do i get my KPI to remain Static if any filters are selected. I dont want my below KPI to change.

Count({1< DateId = {">=$(=Max(DateId))"} >}distinct[Judge ID])/
Count({1}[Authentication Email])

The Date Picker Using the Date Field keeps changing the above KPI.

Regards,

Jamie

rwunderlich — Wed, 21 Jul 2021 16:35:52 GMT

You are on the right track using {1} to ignore filters. You just need to add {1} in the Max() function.

Count({1< DateId = {">=$(=Max({1}DateId))"} >}distinct[Judge ID])/
Count({1}[Authentication Email])

jamiemcc — Thu, 22 Jul 2021 09:01:32 GMT

Thank you so much Rob. This Worked. 😄

Have a great day.

Regards,

Jamie