Charts for Previous Month

[#1]

Hi all,

I am trying to have a chart only show values for the previous month. I have tried adapting the answers on here but cannot get them to work. My date field is Date_LOH. Currently without a month field the equation is:

Count([Job # LOH]).

Any help with this will be greatly appreciated. Thanks!

[sunny_talwar]

May be this

Count({<Date_LOH = {"$(='>=' & Date(MonthStart(Max(Date_LOH), -1), 'DateFieldFormatHere') & '<' & Date(MonthStart(Max(Date_LOH)), 'DateFieldFormatHere'))"}, MonthField, YearField, MonthYearField>} [Job # LOH])

[Anonymous · Accepted solution]

If it is always previous month relative to today (not relative to a selected month), it is a rather simple expression:

count(if(InMonth(Date_LOH,today(),-1), [Job # LOH]))

Here -1 points to the previous month.

Your can replace today with a variable or a field value, and in this case any date can be used as a base.

[#4]

Thank you so much!