How to get in one report the number of tickets created or closed per month and the backlog at the last day of every month in one report

[Patrick Hankar1]

In would like to get on 1 report

-the number of incident tickets created per month (column)

-the number of incident tickets closed per month (column)

- the number of open tickets (backlog) at the last day of each month (line)

See enclosed what I expect it would look like

The first two line are easy to get on a simple report using multiple datasets, but how to add the third one (may require PA) ? 

[DJL2]

Hi Patrick,

It's not possible to retrospectively capture a count of Open incidents because you are measuring against a State field and not a date field.  Once you set the Indicator up, it'll collect and store a score from that point on.

An alternative is that, if you have an idea of what those historical numbers were - perhaps you collected and noted down manually - it is possible to enter those figures into its Scorecard, in order to build in some historical numbers.

But if you don't have those numbers, you've stumped I'm afraid.

Thanks,

DJL

[NikEng1 · Accepted solution]

Hi!

Make sure your indicator source is set up for monthly frequencies:

With that set up, even if you historic jobs is set with a "days ago" intervals (for example a start date of 180 days ago) you will still only get one score per month. If the indicator source is set to daily, so will the automated indicator, and you will get a daily score of all the incidents open that month.

[ab567]

@Patrick Hankar1 , 

Hi Patrick

Same requirement I need to implement can you please share how you have achieved it with step by step method with screen shots?