duplicate records by dimension

[TomBond77]

Hi experts

I need to find all duplicate "equipement" records in a timestamp. Currently I have this formula:

alt(aggr(count(distinct{<[equipement]= {"=count([equipement]) > 1"}>} 1), [equipement]),0)

How do you reflect the dimension timestamp? I need to find out all equipement duplicate in a timestamp. Thanks!

[henrikalmen · Accepted solution]

You could do it in script:

load distinct [Timestamp], equipment, count(distinct equipment) as EqCount resident mytable group by [Timestamp], equipment;

This principle should give you a counter per combination of timestamp and equipment, i.e. how many times each equipment exists within the same timestamp. To find duplicates you just look at those where the number is higher than 1.

But actually you could try that in a chart as well with the dimensions timestamp and equipment, and then a measure that is count(distinct equipment).