Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
I have below database which has UID and wanted to generate a table which will give me count of duplicate UID based on calculated dimension.
Actually, I wanted to generate a table to see how many users are downloading our content multiple times. Something similar to output table. Please see below (second table).
database:
UID | Content ID | Type |
98 | a19 | A |
99 | c1 | D |
98 | a38 | A |
98 | a40 | A |
103 | d12 | E |
110 | a21 | B |
103 | a11 | C |
110 | b27 | C |
107 | a19 | A |
109 | a19 | D |
110 | c20 | C |
98 | d1 | D |
output:
Number of downloads | =count(UID) |
1 | 3 |
2 | 1 |
3 | 1 |
4 | 1 |
Can you guys help me on this please?
Thanks
Vishal
Try this
Dimension
Aggr(Count([Content ID]), UID)
Expression
Count(DISTINCT UID)