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]

Hi Gaurav,

In the widget configuration, select the Time series as "By month Sum+" to get a monthly view of tickets. Let me know if it worked.

Monthly view :

[gauravbanga19]

Hi Sowmya,

By adding Time series we are getting some changes in the graph but it's not showing right count. For ex: for June month we have only 3 tickets but here it's showing 100k. Can you tell us what wrong configuration we are doing resulting in invalid count.

In the Indicator Source that is attached to Indicator widget, we have only 7000 records

One more query- For Indicators based on formula, is there any change in configuration.We get below error we we use timeseries in wideget

Thanks,

Gaurav Banga

[gauravbanga19]

Earlier we created daily frequency indicator and indicator source then I created Monthly frequency indicator with aggregate as count which is giving below output. Here Mar month showing complete 3 months data collection count, april month is showing sum of april, may , jun instead of individual month data.   Is there something i am missing while defining Indicator or source. I have tried on wiki and communities but not able to get the exact cause.

Thanks,

Gaurav Banga

[sriihs]

Hi Gaurav,

The error that you are getting while using the formula is because you might be doing an average on the formula indicator whereas the timeseries   is by month SUM or SUM +. So a suitable timeseries might be By month Avg or avg+ based on what the formula is doing (whether an avg or a count etc)

Can you send a screenshot of the date fields in the job which is used to run this indicator? It might be that you are using historical dates as input and hence the huge numbers. And from what I learnt recently, check your scoresheet to see the results or the data present there as thats the data that will be shown on your widget.

If you are trying to calculate the number of incidents per month, you can try using the frequency "Daily" and filter created on today.. Then run your job relative for 3 months ago and timeseries by month Sum+. let me know if this works as this is the same filters I used for building a similar indicator.

Thanks,

Sowmya

[gauravbanga19]

Hi Sowmya,

If you are trying to calculate the number of incidents per month, you can try using the frequency "Daily" and filter created on today.. Then run your job relative for 3 months ago and timeseries by month Sum+. let me know if this works as this is the same filters I used for building a similar indicator.

By following this, we are getting month wise data, Now, we are creating a formula indicator as below. Output of this indicator is showing some difference in the average as compared to manual calculation by using the count of the month chart of   individual indicator used in the formula. Are we missing anything?

Thanks,

Gaurav Banga