How Time series calculating By Month SUM + value from formula,based on which Date?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-12-2017 07:28 AM
Hi, I am using formula indicator to display month wise record & Time series as "By Month Sum +" where i am getting output for last 6 months.
Could you please tell me how PA calculating month value,On which date based on Header value of month displaying, from open date or create date ?
Why i am getting Oct month value twice with different value, As i am new to PA, could you please help me on this.
Formula : ([[Number of incidents resolved within 30 days opened]] / [[Number of new incidents]]) * 100
1. Number of New incidents conditions = Incidents Opened on Today
2.Number of incidents resolved within 30 days opened Conditions =Incidents Opened on today and Resolved is less than 31 days.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-13-2017 02:32 PM
You're seeing October twice because you chose the time period of "By Month Sum +". The + on the end of that means that it's going to show you partial reporting time periods. And the column on the far right is the realtime value. The realtime value might be slightly different because it's the value as of when you view the scorecard, whereas the columns to the left of the far right one are the recorded values as of when the indicator last ran.
My suggestion would be to change "By Month Sum +" to just "By Month Sum", which will not report partial time periods, and use the realtime value column to be your in-progress reporting period value.
Hope this helps,
--Dennis R