Chart to display data only for last 6 months

[#1]

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 !

[Gysbert_Wassenaar · Accepted solution]

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)

[#3]

Thank you very much !