Set Analysis: Fix a value for selectors

[AmelieF]

Hi, 

I have a KPI with this value for today:

sum({$}{<startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'}>*<difftolling={1}>} isactive)

How can I modify it so the value won't change when the user select a date in the selectors. (but the value still change when the user select another selector)

[Rockstar7]

by pass the date selections like below:

sum({$}{<Date=,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'}>*<difftolling={1}>} isactive)

[AmelieF]

It does not work 😞

with this statement:

sum({$}{<startdate=,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'}>*<difftolling={1}>} isactive)

The KPI return 1 when the startdate selector is empty or contains today's date but it returns 0 when the startdate selector does not contains today's date.

[BrunPierre · Accepted solution]

Try.

=sum({$}{<startdate =,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'},startdate =>*<difftolling={1},startdate =>} isactive)