Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
May be this
Count({<Date_LOH = {"$(='>=' & Date(MonthStart(Max(Date_LOH), -1), 'DateFieldFormatHere') & '<' & Date(MonthStart(Max(Date_LOH)), 'DateFieldFormatHere'))"}, MonthField, YearField, MonthYearField>} [Job # LOH])
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.
Thank you so much!