How to create an index on a field?

tableaucommunity@tableau.com — Thu, 23 May 2019 08:34:32 GMT

I have a dataset where a key value is duplicated. In the example below, order numbers are duplicated each time there is a status change by a different group (Hold column). I want to be able to provide a row index so I can filter out the duplicates.

Order #	Hold
123456	H1
123456	H2
564653	H1

There are many examples on how to remove duplicate but I actually want to provide an index for them. What I want to see is this:

Order #	Hold	Index
123456	H2	1
123456	H1	2
564653	H1	1

The holds have no time value and the date can be the same date. The order of the counts don't matter so for 123456, H1 could have have the 1 and H2 could have the 2. Maybe count isn't the correct term.

I'm doing this so I can use this count field as a filter which will allow me to count the number of distinct orders in a sheet (where count=1). I can create another sheet that has no count filter. When I drop both sheets on a dashboard I can use standard filters to filter the data. Currently I'm using 2 datasets and not able to use standard filters to filter across the datasets.

In SQL Server I can accomplish this using this in the query:

ROW_NUMBER() over (partition by OrderNumber order by Hold DESC)

I need to do this in Tableau.

Content in Tableau Community Forums

How to create an index on a field?