The Zurich release has arrived! Interested in new features and functionalities? Click here for more

How to report on Total number of days in a month using an Automated Indicator

Eddie5
Tera Contributor

Hi Everyone,

 

I want to fetch total number of days in each month using an automated indicator.

Example : 

January - 31

Feb - 29

March - 31

Eddie5_0-1713991849199.png

 

12 REPLIES 12

Hi @Eddie5 ,

 

I have a similar requirement and I have done all remaining configs. Only place where iam stuck is the part where my indicator needs to fetch mins in current month. I saw your formula. How should I tweak the above to bring minutes in a month? 

 

Also, on which facts table should i base this script on? Since I need minutes in current month?

Eddie5
Tera Contributor

Hi @Swetha M ,

 

Did you follow above instructions carefully?

The solution already provides you hours/minutes in a month

Swetha M
Mega Guru

@AndersBGS  any thoughts??

 

My requirement is to get total availability of applications in a month, in mins. Since i already have a custom field that captures downtime duration in mins, I need an indicator where I can script and fetch mins in current month(30 days, 31 days or 28/29 days).. Iam also not sure on which facts table (and indicator source table) I should base this script on.

 

Any help would be greatly appreciated. Thanks in advance!

Eddie5
Tera Contributor

@Swetha M ,
1. Create a automated indicator to calculate downtime in hours/minutes

2. using above instructions i have provided, calculate minutes/hours per month. i.e. overall availability

3. Create a formula indicator, total availability = (overall availability MINUS downtime)

 

Please click helpful.

Thanks for the response 🙂

 

I have created an indicator to get total downtime in mins already and its fetching data as expected based on CIs.

Inorder to use the script above as in your instructions, I see your script would return mins in a day, so how would we use it for calculating monthly?? "By Month SUM" is an indicator by itself? 

Apologies, Iam new to PA and ive figured the rest, this is the only place where im stuck.