Fixed KPI - Count ignoring all filter selections

[gino2780]

Hi all,

i'm looking for a script command that allows me to create KPI's that (e.g. Count, Sum) always stay the same, although i might have selected certain filters on the Dashboard. My idea is to visualize on one Dashboard fixed KPI's for overall perspective vs. dynamic KPI's (that change with each filter selection) for specific or more detailed KPI's.

Let's say my data consists of 1000 rows. Each row is a customer. Let's say the field is named 'Customers' next to many other fields (columns) in a given set of data. I always want to see the Count of Customers = 1000 in the KPI, no matter which filters i have selected at the same time.

I've looked for some hints here in this forum, but couldn't find the solution.

Thanks in advance,

bye bye

[shraddha_g]

you can ignore all selections in Set Analysis.

For Ex. Sum({1}Sales)

It wont change on any selection.

[sunny_talwar · Accepted solution]

Using {1} is the key here as pointed out by shraddha.g‌.

Count({1} CustomerID)

[gino2780]

Works perfectly fine.

Thanks Shraddha and Sunny

[Murthy]

Hi,

I have prepared a dashboard, which has Month, Function, volumes, Error .

And once i apply filter on Month and Function , The volumes what i get should not get change even if i apply further filetr.

Kindly can you tell how to fix this.