Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Chart table of Meter Serial Numbers and a last reading date(MAX).
I only want the to display the records that have calculate Today() - Max[Reading Date] > 2 .
Please see attached
Any help would be wonderful.
use the below expression in ur chart.
if(Today() - Max([Reading Date]) > 2,Metricfield)
Regards,
Kabilan K.
Many Thanks
Worked a charm