0 votes
1 view
in BI by (17.6k points)

What I have?

I have a dashboard in Tableau which shows different payments received - the amount, the date the payment was received, and a calculated field which shows the number days since the payment was received.

However, lot of payments are same, with the same amount, and received on the same day; so Tableau collapses them together, and adds the total days since the payments were received together in the final column, i.e. five lots of £5.50, each received on 1st January shows as below

Column 1   Column 2     Column 3
£5.50     01/01/2018      155

What I want?

But I need separate rows for each. Does anyone know how to stop tableau doing this, or of a workaround? Many thanks.

1 Answer

0 votes
by (47.2k points)

Tableau has a function RANK_UNIQUE which you can use for this query

As a first step, uncheck the aggregate measures within the Analysis Menu.

Then, starting from this sample data:

enter image description here

You can get the following result: enter image description here

Additionally, if you want to hide Rank from rows -- not-showing header.

Is this something close to what you're looking for?


In order to get all values and not just for the top rows, just move the Rank at the very beginning of the shelf:

enter image description here

Welcome to Intellipaat Community. Get your technical queries answered by top developers !