Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Count(DISTINCT {<[LAST_MODIFIED_DATE] = {"=Floor([LAST_MODIFIED_DATE]) = Today()"}>} GAGE_SN)
Try this
Count(DISTINCT {<[LAST_MODIFIED_DATE] = {"=Floor([LAST_MODIFIED_DATE]) = Today()"}>} GAGE_SN)
It worked! Thank you