Highlight & Filter Duplicate/repetitive Values in Chart-Straight table
"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()) "