Count Distinct on Incident_Metric -> Number column

[brandimore]

Hello

I would like to count distinct on the Number column in this table. Unfortunately it's not an option when I go to review the list of Aggregates. I saw another post about creating a new Indicator and Source for this to work. This seems like a lot of work for something this simple, but I did this anyways. When I'm in my report it's not an option to select.

I want to make sure that I'm not making more work for something. Can someone confirm how you can make a new field as an option to Aggregate?

Thanks

Instanbul is the version I'm running. We do have PA also.

[niveknonrev]

I know this is old but I came across the very same need and ended up solving it a different way.  We implemented some more SLA's and I was able to use the count distinct on "tasks" since it is the same as the incident number, to get what I wanted. Specifically to track when someone actually did work on a ticket we made this one INC M Work In Progress

Start condition with

Stop condition

Then you can use a pivot table to display how many distinct tickets they "worked" on

Now clicking on any number will take you to the list and still show duplicates, but you get the "count" on the pivot table. 

These type of SLA's also provide benefits like showing how long they actually worked on a ticket and how long it was in each state.

May not be useful for you, but it helped us greatly.

Thanks

[Jessica6]

You can try to set the count distinct field to the ID field in the metric. This is a reference field to the specific task. In the report output the number of records is only shown based on unique values, however when you click on the bar in the report to open the results, all records (including double) are shown.

So keep in mind that only the report shows the number of records based on the count distinct.