Monthly View Widget

sriihs
Tera Expert

Hi All,

I am trying to build a widget that shows the average of the service_availability column on a monthly basis. In the indicator source, it shows that it is collecting records for all the months. Even on the widget if I see the records tab it is showing the records for all month. But in the display it is showing the percentages just for current month and last month and just for 1 month if I select the time series as 'By Month AVG'. How can I adjust this widget to show by month for all the months for which it has data? Screenshots below:

Scores are shown just for 2 months:

find_real_file.png

Records available for the start dates   going upto 6 month back:

find_real_file.png

Thanks,

Sowmya

1 ACCEPTED SOLUTION

Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

You need to tell the collection job to run for more periods back. Please take a look at the below documentation entry:



Collect historical data



Best regards,


Erik


View solution in original post

11 REPLIES 11

Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

Did you collect for more periods back?



Best regards,


Erik


Yes, It did collect for more periods back, right upto 2014.


find_real_file.png



Widget configuration :


find_real_file.png



Widget just showing data for current month and May 2016:


find_real_file.png


Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

Records does not tell the story about scores being available -- the records are the underlying rows that are used to calculate the score for month June your screenshot.



Please go to Scoresheet and select the indicator, and check the scores. Or go to the scores tab (next to records tab) in the scorecards, and check the scores collected.



I notice that you breakdown by service. Perhaps there are no scores for that service.



Best regards,
Erik


You were right! I do not see any scores for previous months in the scoresheet. How do I ensure scores collect for previous months? I thought if the records are available then the scores are being collected. I changed some of the conditions on the indicator source and clicked on the link to see the records that match the condition and I can see records for all start dates going back upto 2014. But after I ran the job, it shows me scores just for this month. What could I be doing wrong here?



Records in the matching records link in the indicator source:



find_real_file.png


Scoresheet:



find_real_file.png


Erik Hoffmann
ServiceNow Employee
ServiceNow Employee

You need to tell the collection job to run for more periods back. Please take a look at the below documentation entry:



Collect historical data



Best regards,


Erik