This should be an easy one, but no matter how I write the Today() condition in this set analysis expression, I end up having a blank chart: I want to show the average verification time for events with a certain status (31) and that started today.
I've tried several alternatives, with no luck:
If I write the date, it does work:
Any idea on what might be wrong with Today()? This seems like a syntaxis issue, but I can't see what the mistake is.
Works! Thank you, Sunny.
One thing I'm noticing though. Today() is returning yesterday. I've used KPIs and they show the following:
Now()= 11/22/2017 1:51:13 PM
I've checked the date in the PC is right and I've just done a data load. Any reason for Today() to return 11/21?