I'm able to display duplicate values by adding a count measure that's tied to my field hash id. I then added a filter for count > 2. That shows all the duplicates but only the 2nd entry of that same hash id. I want to show both the first and 2nd instance how would I achieve this? I personally can't edit look ml at the moment so I'm hoping this can be achieved with expressions. Thank you!
This is a Basic Example of How its showing now
Hash ID | URL | Count |
1234 | jpg2.com | 2 |
1235 | jpg4.com | 2 |
1236 | jpg6.com | 2 |
This is how I would like it to show whether or not the count column displays a running count doesn't matter to me.
Hash ID | URL | Count |
1234 | jpg1.com | 1 |
1234 | jpg2.com | 2 |
1235 | jpg3.com | 1 |
1235 | jpg4.com | 2 |
1236 | jpg5.com | 1 |
1236 | jpg6.com | 2 |
bumping