last 6 months tickets count

[0li5a3a]

Hello,

could someone help me to display the open ticket for the last 6 months  into a Bar Chart ?

Please find the files attached.

I want to see the month:

November,December, January, February, March, April(this is the current month)

[MK_QSL]

Use this expression

count({<Status = {'Open'}, OrderDate = {">=$(=MonthStart(Today(),-5))<=$(=MonthEnd(Today()))"}>}[Ticket ID])

or

count({1<Status = {'Open'}, OrderDate = {">=$(=MonthStart(Today(),-5))<=$(=MonthEnd(Today()))"}>}[Ticket ID])

[rubenmarin · Accepted solution]

Hello Constantine, PFA, the expression is set to show data of the last six 6 months (april doesn't have data) ignoring selections.

To show april you can edit your calendar to:

Let varMaxDate = Num(Today());

[0li5a3a]

Thanks, I checked the calendar, all sorted because of u:)