Set Analysis

[artempotsuray]

Hi I'm trying to count the number of gages that have a LAST_MODIFIED_DATE of the current system date. I'm pulling data from a sql server so the LAST_MODIFIED_DATE column changes periodically for ever gage. I have this written but it is not giving me a result into a KPI:

Count(distinct {<Date([LAST_MODIFIED_DATE],'MM/DD/YYYY') = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

I also tried:

Count(distinct {<Date(Floor([LAST_MODIFIED_DATE]),'MM/DD/YYYY') = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

and

Count(distinct {<[LAST_MODIFIED_DATE] = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

but the LAST_MODIFIED_DATE data has a timestamp with the date which I don't need to look at.

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT {<[LAST_MODIFIED_DATE] = {"=Floor([LAST_MODIFIED_DATE]) = Today()"}>} GAGE_SN)

[artempotsuray]

It worked! Thank you