Dashboard showing MTTR Month over month for 12 months

Go to solution
Asha Pathak
Tera Contributor

‎03-09-2025 04:42 AM

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

 

AshaPathak_0-1741518811749.png

 

AshaPathak_1-1741518840063.png

@ indicators

 

AshaPathak_4-1741518990274.pngAshaPathak_5-1741519014987.png

 

Indicator source

AshaPathak_10-1741520185522.png

 

AshaPathak_11-1741520230527.png

 

 

 

Job 

 

AshaPathak_9-1741519219148.png

 

 

 

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!

 

AshaPathak_12-1741520474086.png

 

 

 

0 Helpfuls
  • 937 Views
1 ACCEPTED SOLUTION

Go to solution
Shivalika
Mega Sage

‎03-09-2025 05:02 AM

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

View solution in original post

8 REPLIES 8

Go to solution
Asha Pathak
Tera Contributor
In response to Shivalika

‎03-10-2025 05:27 AM

@Shivalika ,
I have added below query in formula indicator.
[[Sum of Business resolve duration of all incidents]] / [[Total number of incidents]]

It showing correct result.

I have added one breakdown for the assignment group.

But when applying breakdown , formula not working
Could you please tell me the query for assignment group condition?

I have added assignment breakdown in MTTR formula indicator  

0 Helpfuls

Go to solution
Asha Pathak
Tera Contributor
In response to Shivalika

‎03-09-2025 07:43 AM

Hello @Shivalika ,

It will not show January month records.

Actually data is available in table

AshaPathak_0-1741531373988.png

 

0 Helpfuls

Go to solution
Shivalika
Mega Sage
In response to Asha Pathak

‎03-10-2025 05:29 AM

Hello @Asha Pathak 

 

Please open a new thread for new queries 😊. 

 

I will reply on that as soon as you have posted. 

 

Regards, 

Shivalika 

 

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

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

0 Helpfuls