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]

You should set relative end to 1.

That is the same story, setting it to 0 you look at the cuurent month so in this case the en_date will be set to 31-10-2017 23:59:59

This will give unexpected results probably.

Again, make sure to delete the scores, just rerunning it will keep the last month.

[brandimore]

Thanks Anroud. Yes that makes sense. I think I may have it. The Relative start (according to the documentation) is based on the current date the job is ran. So if I want the start to always be August, I'd do Relative Start = 2

This is looking more accurate. I am going to verify the numbers.

Thanks so much for all your help, again.

[Arnoud Kooi]

Good, hope it works as expected now!

Just for clarity, In oktober -2 months is august, next month it will be september

[brandimore]

Mmmm so it doesn't appear you can have a Fixed start and a Relative end then? Maybe I misunderstood the documentation.

We want the start date to always be August 2017 (go live date) but the end to be month -1.   Is this possible? If not, is it best to put the Relative start = 0 ?

[Arnoud Kooi]

Why would you want to always start in august 2017.

You only need a historic collection once, after that the historic data should not change, so relative start and en can be both set to 1 month.