Need Help to build time series graph in performance analytic

[shipra]

Hi Everyone,

I am trying to build a Time Series( Line Graph) calculating average of a particular field. It is successfully calculating the average, the problem is for everyday it is showing the same average. I want to breakdown the report based on another field. I have created a breakdown but it is not working. Another doubt, is that i have a 'Timestamp' date/time field and i want the data to show average according to the dates stated in that field, instead it is referring to the system's 'Created' Field's date.

Also, what is the significance of 7d running SUM, 7d running AVG, etc. I am calculating Average on Field's value, when selecting the 7d running SUM, the graph shows cumulative sum of the average, but the same for 7d running AVG is not happening. The job i have created is running successfully. Need some guidance for creating this report. Kindly let me know if anyone has any clue regarding this.

Thanks in advance,

Shipra Shaw

[sriihs]

Is the re-opened tickets for all the sources? Because if you look at the numbers, it looks fine..for example for the month of DEC you have around 3000 tickets and the re-opened ticket is just 1. So   the % looks logical to me.

[gauravbanga19]

Yes, it's re-opened tickets for all source.

Since the individual indicators used is configured with daily frequency, does the formula indicator applies the formula on daily data collected and then AVG the output or it first SUM month data then applies the formula. Because if it apply it after 'By Month Sum' then there is some discrepancy.

[sriihs]

Hi Gaurav,

In Your formula indicator use the unit as % , add a precision as 2 and in the formula multiply by 100 to get a percentage view.

For example, here is the formula for the Percentage of new critical Incidents :

( [[Number of new incidents / Priority / 1 - Critical]] / [[Number of new incidents]] ) * 100

Let us know if it works.

Thanks,
Sowmya