How to report on Total number of days in a month using an Automated Indicator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2024 01:16 PM - edited 04-24-2024 01:51 PM
Hi Everyone,
I want to fetch total number of days in each month using an automated indicator.
Example :
January - 31
Feb - 29
March - 31
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago - last edited 4 weeks ago
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hi @Swetha M ,
Did you follow above instructions carefully?
The solution already provides you hours/minutes in a month
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago - last edited 4 weeks ago
@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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
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.