Hello!
I wanna know if it is possible to calculate the number of occurrences of a repeated value in a column. For example i have this:
And I want to create another column that shows the number of occurrences of each id. For example, for id 41246261004 is 2, for id 41244724964 is 1.
How is it possible? Thanks
Make a measure with “type: count” in the view file.
measure: count {
type: count
}
If you then use this measure together with the dimension in your picture, you will achieve your desired outcome.