Distinct Count in Reporting

[Jane Stone]

Does anyone know what determines which fields are available for selection when choosing the Distinct Count option in Reporting? My scenario is that I am reporting using a database view that has multiple rows per change request. I created a trend report based on the planned start date but I want the count in the bar to be based on the number of change records, not the number of rows in the data. If I choose the option Count Distinct only certain fields are available and the change number field is not one of them. Does anyone know if there is a way to make it available?

[Alberto Consonn]

Hi,

have a look at the solution provided to the discussion above, it will help you to fit your need:

Count Distinct on Incident_Metric -> Number column

Please, remember to mark Correct or Helpful if you find my response useful.

Cheers
Alberto

[Alberto Consonn]

Any update on this?

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

[Jane Stone]

I'm not sure I do fully understand the solution. There are so many things going on in that article. Are you saying that I could run a one time background script and it would then make the chosen field available for Count distinct within Reporting application?

[GD11]

@Alberto Consonn @Archana Natara1 @Jane Stone 

I have similar requirement on a custom table which has ID field, I want to have list report filter on distinct ID's as ID's are duplicate, is there any way do it?

list editing is already enabled in our instance.