KPI to count items that have expired date

[JBLayton]

Hi all,

I am building a dashboard at work at the moment and Im wanting to create a KPI to count how many items have a date which is expired(before the current date). Is this possible? and if so, how could I write the expression?

[AshutoshBhumkar]

Hi,

You can create a flag in the script and use that flag in the front end expression.

e.g

Script flag : If (Date < today(), 1,0) as Flag     //1 flag for every item which has dates less than today

Front end expression would be like :Count({<Flag = {'1'}>}Items)

Thanks,

Ashutosh

[JBLayton]

Thanks, I will try this now.

What do I need to put in to replace items?