Using Set Expressions to limit Expression values

[Anonymous]

I have a bar chart, and I want to limit it to a 4-month sliding window, current month and three previous months.  I have assembled the following set expression via suggestions on here, but it does not filter at all.

Count ({1<date = {">=$(=MonthStart(AddMonths(Today()-3)))<=$(=MonthEnd(Today()))"}>} ticket_type)

My data essentially looks like this:

ID	Month-Year	date	ticket_type

I am trying to accomplish something similar to this:

[maxgro]

maybe a missing comma in the AddMonths function

Count ({1<date = {">=$(=MonthStart(AddMonths(Today(),-3)))<=$(=MonthEnd(Today()))"}>} ticket_type)

[Anonymous]

Well, not that ... lol now it is completely blank.  so I apparently have done something wrong

[Anonymous · Accepted solution]

I have finally gotten this to work.

I used

Count({<[Month-Year] = {">=$(v3MonthsAgo)"}>}JOB_ID)

where

v3MonthsAgo

is defined as

LET v3MonthsAgo = MonthStart(AddMonths(Today(),-3));