Need help in creating KPI for current month

[Shaunvijayan002]

Hello All, I am trying to create KPI for current month and below is the script I am using

Avg({<[end_Month]={"$(=monthname(Max(end_Month)))"},Type={'Events'}>}IN_MTTR)

I noticed that if I have data for say July-21 then it shows the data for July and if there is no data for July-21 then it shows the data for June-21

What is the command that I can use so that it can show be blank if there is no data for current month?

Regards

Shaun Vijayan

[kaushiknsolanki]

You can change the expression like below.

Avg({<[end_Month]={"$(=monthname(today()))"},Type={'Events'}>}IN_MTTR)

Change Max(end_Month) to today().

[Shaunvijayan002]

Thanks Kaushik.

What would be the script for previous month?

[kaushiknsolanki · Accepted solution]

Avg({<[end_Month]={"$(=monthname(addmonths(today(),-1)))"},Type={'Events'}>}IN_MTTR)