Display Last Three Months

[Anonymous]

The current equation below works to display max load date:

LOAD_DATE = {"$(=Date(Max(LOAD_DATE), 'YYYY/M'))"}

However, I would like the chart to display last 3 months. I tried below but this did not work.

LOAD_DATE = {"$(=Date(Max(LOAD_DATE) - 2, 'YYYY/M'))"}

Any suggestions?

Thank you,

- dave

[Anonymous]

Correct. With the BL_Month=> part of the expression I am seeing no data.

I think I may have found a solution. I add a '1' after the count syntax.

Count({1<Field1={'Value1'}, Field2= {'Value2'}, LOAD_DATE = {">=$(=Date(AddMonths(Max(LOAD_DATE), - 2), 'YYYY/M'))"}>} Line_ID)

[sunny_talwar]

If you add 1 then your expression won't change on any selection. If that is acceptable then 1 will work out

Best,

Sunny

[Anonymous]

Thats fine. I believe the chart will still show the previous 3 months regardless of selection which is the desired effect.

Thank you very much for your help!

[sunny_talwar]

Yup no problem. I am glad it worked out.