Monthly Indicator source, showing the same result every month

[veronica_malmo]

Hi all!

Another challenge here today..

I want to collect the score of how many open incidents an assignment group has every month. If I use the daily indicator, the numbers gets all wrong when I do a SUM by Month, because of course it adds all the records for each day together..

Then I thought of collecting only the incidents thar are open on the last day of the month, that way we can trach the backlog from month to month. I created an indicator source (Incidents.open.Monthly) and set the Valid for frequency to Monthly,   Fact table to Incident, conditions to: State is not one of: resolved, Closed.

Now I get the same result for every month, looking closer I can see that the records listed for January was not created until May so how is this possible? How to fix this? And do I have to create a job so it only collects once a month?

[brandimore]

Thank you! I am going to try this on Monday!

[Arnoud Kooi]

If you choose type timeseries, you can add extra indicators via the related list Widget Indicators

Check OOB widget Number of open Incidents:

[brandimore]

Thank you! I will give this a try on Monday. This could be really useful.