How to change date to MonthStart?

[#1]

Hello,

The following is what we're using to create our date fields. How would I manipulate this to be the month start date?

Month(MakeDate(left(right('$(vVulnerabilityFile)',11),4),left(right('$(vVulnerabilityFile)',6),2))) AS MNTH,

Thanks!

[sunny_talwar]

These did not work?

Sum({<MonthStart={"$(=Max(MonthStart))"}>}CRITICAL)

Sum({<MonthStart={"$(=Max(MonthStart))"}>}HIGH)

[#3]

Nope. Maybe I should clarify what i'm trying to obtain.

I want a pie chart that shows critical, highs, and lows for the previous month.

If I do sum(CRITICAL), etc it will work just fine, but that is for all time. How do I get it to just show for the previous month?

[vishsaggi]

What is the format of your MonthStart? Is it MM/DD/YYYY ?

[#5]

yes

[sunny_talwar]

Previous should be this

Sum({<MonthStart={"$(=AddMonths(Max(MonthStart), -1))"}>}CRITICAL)

Sum({<MonthStart={"$(=AddMonths(Max(MonthStart), -1))"}>}HIGH)