Add a field on the Count Distinct aggregation options for reports

[JC S_]

We are trying to create a report from the incident_metric table and we want to count the distinct values from the "Value" field. However, we can't see the field "Value" on the choices. How can we add this field on the count distinct choices?

[Ankur Bawiskar]

Hi Jimboy,

incident_metric table could not be located in demo instance. Is this a valid table.

Can you explain more on this?

Regards

Ankur

[JC S_]

This is a Database View, sorry about the confusion.

[gtalreja]

Hello Jimboy

You can only use the "Reference fields" available in the Table when using the Report module. But if you use Performance Analytics and create indicators, you can use any type of fields for count distinct.

Regards,

Gaurav Talreja

[Ct111]

Hi Jimboy ,

Please refer this thread and do let me know if this solves your problem.

Count Distinct on Incident_Metric -> Number column

Please Like The Answer and Mark it Helpful if it helped in your scenario