Dashboard showing MTTR Month over month for 12 months

[Asha Pathak]

Hello Community!

I have requirement to create report to calculate MTTR of particular month for 12 months.

For that I have created 1 widget, 1 formula indicator , 2 indicators for the formula and scheduled job.

Formula indicator

@ indicators

Indicator source

Job 

It shows correct output for this month.

But it dosen't show result for previous months.

Go to previous month is disabled.

How to calculate data from previous month?

Please help!

[Shivalika · Accepted solution]

Hello @Asha Pathak 

Please check that valid for frequency for all is set to monthly.

Also for the scheduled job please change the relative start date to 31 days ago and relative end date to 1 day ago. It needs to collect whole month data for it to calculate it. You are only collecting 1 day data. 

I have done this last week exact same and it's working just fine. 

Please mark my answer as helpful and accept solution if it helped you in anyway. 

Regards,

Shivalika

LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

YouTube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=WW9HJMBd2aREIMEg

[Asha Pathak]

@Shivalika . Thank you so much!! It works

[Asha Pathak]

@Shivalika 

Currently It showing data only for current month and when we click on 2 days It shows correctly.

can we add data for the all 12 months on the report ?

[Shivalika]

Hello @Asha Pathak 

No, it's not possible to show all the 12 months on the front view, you need to click on it and change the months to see the 12 months data. Else it will only display for two months on front. 

Regards, 

Shivalika