Count Distinct for a Risk Map Report

[LAMartinM]

Hello, 

I am trying to generate a riskmap report with groupby probability and damages in EUR. As a count of I am using the name,  but I would like to count just distinct names and not duplicates.

Does anybody know how to do a distinct count of in a report in Archer?

Thanks!

Ligia

[Ilya_Khen · Accepted solution]

LAMartinM,

If your source data contains several the same names and your grouping+counting by it, then there is no way to make statistical report to count name only once. You have to change your source then.

[LAMartinM]

Thank you for the answer @Ilya_Khen 

with changing the source you mean I would have to create another application where the names are unique? 

[Ilya_Khen]

Well, either this or change your report somehow. But yes, it is all about source.