How to add IF null statement to current expression

[#1]

I am currently counting First discovered dates, how would i add

"count first discovered within the last month IF Closed_mitigated_On is null'

Open:

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}> } First_Discovered)

Also, I am looking to add a compliance flag into this this chart. How would I write Count(compliance_flag for the last month)

the above count statement isn't working.

[Gysbert_Wassenaar]

Not sure what you want. Perhaps this:

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}, Closed_mitigated_On-={'*'} >} First_Discovered)

[Anil_Babu_Samineni]

"count first discovered within the last month IF Closed_mitigated_On is null'

For this, You can use like below

If(IsNull(Closed_mitigated_On), Count({<Month = {'$(=Max(Month, -1))'}>}[first discovered]))

Or

If(IsNull(Closed_mitigated_On), Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}[first discovered]))

Also, I am looking to add a compliance flag into this this chart. How would I write Count(compliance_flag for the last month)

the above count statement isn't working.

For this, you can write like below

Count({<Month = {'$(=Max(Month, -1))'}>}compliance_flag)

Or

Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}compliance_flag)

[#4]

None of these worked

[Anil_Babu_Samineni]

Would you explain more please

[#6]

the 'month' isn't working and it isn't returning any data.

Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}compliance_flag

How to add IF null statement to current expression

[Anil_Babu_Samineni]

May be you don;t have month field. Use same month field if you have and then count of that

[#8]

it still says "expression Ok" but doesn't return any values.

the compliance flag has "compliant" and "non compliant'. so the current expressions for my chart are "Open", "closed" and I want two more that are "compliant" and "non Compliant" that show data from the last month.

[Anil_Babu_Samineni]

Is there any chance to share application?

[vinieme12]

Try

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}, Closed_mitigated_On ={"=len(Closed_mitigated_On )=0"} >} First_Discovered)