Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Thanks, I will try this now.
What do I need to put in to replace items?