Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create some pie charts but I want my data to be only for the last 6 months, not longer.
I want to count(Distinct CaseNumber) based by the field 'Date'.
Do you have any idea how can I achieve this ?
Thank you !
You can use a set analysis expression to select the Date values of the last six months:
count({<Date={'>$(=AddMonths(Max(Date),-6))'}>} Distinct CaseNumber)
You can use a set analysis expression to select the Date values of the last six months:
count({<Date={'>$(=AddMonths(Max(Date),-6))'}>} Distinct CaseNumber)
Thank you very much !