Monthly View Widget

[sriihs]

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:

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

Thanks,

Sowmya

[Erik Hoffmann]

Can you publish the indicator source?

Based on the records I suspect that in the collection all monthly service_availability records are used, instead of just the one for the month. Your indicator source should include a statement like 'end in current month'. Otherwise it calculates service availability of the month based on all months.

Best regards,

Erik

[sriihs]

Hi Erik,

This is what we are using in the indicator source, please advise what I might be doing wrong on this one :

[Erik Hoffmann]

With start on today or start before today you will query all service_availability rows before today in the monthly scores collection cycle. Therefore you also had service_availability rows for scores not belonging to the month. You probably only want the ones for the month. Right now it basically is sort of rolling average of all previous months.

If that is what you want it is okay. But I think you only want the availability of the month so I think you should do condition 'start on this month'. This way the monthly collection cycle takes only the rows for the month. I am not an expert of monthly collection cycles so please play around with the conditions.

Any easy way to check is to click the link that tells you how many records match the condition -- this shows if you would collect right now which records/rows are being included.

Best regards,

Erik

[sriihs]

Thanks Erik,

What I want is to show the availability for all the months, for example, Feb 99%, March 98.5% , April 100% and so on..

It seems to be collecting the records but only when displaying, it seems to display just for this current month and just 1 month back.