How to count incidents assigned to my group for last month ?

[Christophe K_]

Hi Experts,

i made a report to count the number of incident that was assigned to one of my groups for last month.

I used incident_metric. it gave me all incidents that was affected to one of my groups. BUT if the same incident came 2 or 3 time to my groups, it is count 2 or 3 time in the report.

i tried to use "distinct count" but the "incident number" does not exist in the list..

i saw many questions about this problem and answers was always to use a script .. But How to do without a script ?

it's really not possible to count the number of incident assigned to a group for the past month ? it seem a so simple question everyone need to answer ..

Data : incident_metric

Type : Single score report

Aggregation : Count

Home someone would be able to help.

Best regards.

Chris

[Michael Fry1]

You're on the right track, just need to add some conditions to further filter.

Table is incident_metric

Conditions: Definition - is - Assignment Group, Value - is - [name of group], Created - on - last month.

That should give you a count.

[Christophe K_]

@Michael Fry,

thanks for your fast answer, and sorry about not posted my conditions :

Conditions: Definition - is - Assignment Group with calendar, Value - is - [name of group], Created - on - last month.

Now, about your conditions, I tested them and I think the definition : Assignement Group, give only the current assigned  incidents, not the ones actually in another assigned group but passed in my group..

The conditions I use are working , but a bit too much.. if an incident was assigned to my group then to another then again To my group, it will be count 2 .. me I want 1 

I also tested with the metric : first assigned group.. but my group is not always the first assigned group so in the count, some incidents are missing.. 

thx 4 the help

[Michael Fry1]

That is the problem with using field Metrics because there could be some duplicates. You could certainly create a script Metric but that won't capture data in the past, just when the Metric is loaded.

[Christophe K_]

This is really strange that out of the box (I mean without script), such a report can’t be done, it’s a “basic” question, no ?