I faced a problem with dates comparison in set analysis.
Here's an expression:
and this expression doesn't work cause there are two rows to be excluded from the given result. I need verificationDate to be between FDLink and TDLink but I can't get it working.
Comparing FDLink and TDLink with now() gives the expected result.
Count has to be 208 for Nov 2017
Solved! Go to Solution.
Unfortunately, didn't work.
Interesting that if you make a table with ExtIDDevice and this expression:=if(verificationDate <=TDLink and verificationDate>=FDLink, 1,0), after that select 1, count will be 208...
I made another file - it's almost the same. it also contains the condition which I was telling about and verificationStatus.
Distinct count from highlighted rows on the ExtIDDevice field gives 208 for Nov 2017
Set analysis is evaluated once per chart and what you needed was a row level check... so you need to use if or you can create a flag in the script and then use that flag in your set analysis