Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
I need to show only duplicate values in table chart.
My table is like this
Id | Name |
---|---|
101 | A |
102 | A |
103 | A |
104 | B |
105 | B |
106 | C |
107 | D |
108 | E |
109 | F |
110 | G |
111 | G |
112 | H |
113 | I |
I need like this in table chart
Id | Name |
---|---|
101 | A |
102 | A |
103 | A |
104 | B |
105 | B |
110 | G |
111 | G |
try a straight table with
dimension
Id
expression
only({$ <Name={"=count(Name)>1"}>} Name)
try a straight table with
dimension
Id
expression
only({$ <Name={"=count(Name)>1"}>} Name)
Hi Massimo
This is what I needed
Thank you
Hi Massimo
I have one more question related to this.
Can we count number of duplicated rows as KPI , that means 7
Its ok
I got it
Count(Aggr( only({$ <Name={"=count(Name)>1"}>} Name),Id))