Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try.
=sum({$}{<startdate =,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'},startdate =>*<difftolling={1},startdate =>} isactive)
by pass the date selections like below:
sum({$}{<Date=,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'}>*<difftolling={1}>} isactive)
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.
Try.
=sum({$}{<startdate =,startdate = {"$(=Date(Today(), 'YYYY-MM-DD'))"}>*<alerttype = {'flagAbnormalTolling'},startdate =>*<difftolling={1},startdate =>} isactive)