Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying put a chart to display no name create in the last 90 days by title.
here is my ruff data:
the result may come below
Title Count
D 1
E 1
I 1
Can some one please advise what expression should work to display no name in last 90 days by title?
Thanks,
Dinesh
Maybe something like
sum(aggr(if(max(Create Date)<today()-90,1),Title))
Might need some tweaking to get the desired result but that should help point you in the right direction.