Highlight & Filter Duplicate/repetitive Values in Chart-Straight table

[himani_a_agrawa]

"Hi All,  Please help me on this topic. I know there are many post regarding it, but couldn't find relevant solution. Here is the detailed description of my issue:I have a straight table, where I am showing DeviceName, IP address, Country etc, on the basis of some expression in expression tab and some calculated dimension also. Now After calculation, there are list of values that appears in the table, have duplicates, or can say repetitive values. Now my requirement is to give a user a button, so that they can see: 1. duplicate records, (device name) 2.  duplicate records, (ip_address) 3. Filter out only duplicate records in the table( device name /IP) like we used to do in excel.  Also, for highlighting , i used the below formula, but when I used the same formula to highlight another column in the same table, it is not highlighting.  if(DeviceName = below(DeviceName) or DeviceName= above(DeviceName) , Green()) "

[Arthur_Fong]

Can you provide a sample app?

[himani_a_agrawa]

Attached is the mock file for your reference. 

[sunny_talwar]

For highlighting, try this

=If(Aggr(NODISTINCT Count(DISTINCT apparent_ip), DeviceNameAll) > 1, Green())

[sunny_talwar · Accepted solution]

Here is a solution for Showing Duplicate when Duplicate Name button is clicked

Button Action -> Set Variable

Variable = vToggleViz6
Value = '=If(vToggleViz6 = 1, 0, 1)'

 

Change the dimension DeviceNameAll to 

=If(vToggleViz6 = 1, DeviceNameAll, If(Aggr(NODISTINCT Count(DISTINCT apparent_ip), DeviceNameAll) > 1, DeviceNameAll))

[himani_a_agrawa]

Thanks Sunny, this worked. 

Thank you so much.

[sunny_talwar]

Awesome 🙂