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?

[Arnoud Kooi · Accepted solution]

I guess you need to add a condition, this one is for a daily indicator

BTW, it would be usefull if you could add screenshots

[veronica_malmo]

Thanks a lot, that helped yes, should have seen that myself though, but my brain was fried at the moment

[brandimore]

Hi Veronica - Is this working for you? If so could I ask you a few questions as I'm trying a monthly backlog report

[veronica_malmo]

Hi,

Yes this works for me, burt I have made I slight change. Now instead of having a monthy indicator, I have a job that runs the first day of every month (so the last day of the month data is collected, this way the data is displayed for the correct month).

Just ask, and I'll see if I can answer!