Performance analytics - Data from last 30 days

[Blair5]

I'm creating an index of several indicators. The data is for over the last 30 days. I created all of the indicator sources to look at the last 30 days and found a post (can't find it now) stating that indicator sources should almost always collect for 'opened on today'. So I recreated a few of the indicators to test this out and am getting different results. What is the proper recommendation? Since this in development, I want to make sure it's done correctly. Don't want a year to go by and find out it was set up incorrectly. See example of differences in attached.

[Blair5]

Padmanabam,

Did you see my post about the records coming back? It seems the daily collection brings back daily results instead of the last 30 days as stated in the indicator. I added the 30 day running sum, but just want to make sure that is correct before I modify the other 13 indicators in my index.

[Padmanabam Tiru]

Hi Blair, If you specifically wants incidents created last 30 days, i would suggest to go with Reports rather than PA. Reports will give you straight forward conditions in condition builder. PA is more useful to figure out the trends of incidents   creation based on historical data, if you are so specific about last 30 days then its better to go with Reports. As you used in condtions created on Last 30 days, when you used 30 days running sum obviously you will see wrong results because say on jan1 when you ran this job it collects the incidents created for december and on jan2 it collects the records from dec2 to next 30 days and so on, so for ex if on jan 1 if there are 100 records and jan2 if it becomes 120 when you use 30 days running sum it sum ups these 100+120+ and so on for past 30 days which is obviously wrong,actually our expection is only incidents created on last 30 days. If you want PA in this use case, just specify created on today and run the job for past 3months or whatever you wish. Now once the data is collected, if you apply 30 days running sum, it gives you for last 30 days incidents created. Please try this and let me know if you find any discrepancy again.

[Blair5]

Padamanabam,

We want to see a trend over the last year based on P1 incidents created over 30 days. If there is a spike, we will be able to see it in PA. Since the indicators are viewed in a scorecard, I applied the 30 days running sum on the indicator itself. It seems accurate. Just want to make sure I'm doing it correctly.

[Slawek_Radziewi]

Hi

I am using By Month Sum+ but I think you would have to just compare with real table and check what results are more feasible and suitable for you.

[Adam Stout]

Yes.   From what you described, you would want a daily indicator with a time series to rollup the data.   This can be done on the widget or in a formula.