How to combine rows with same information in Tableau

0 votes

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 (as of 01/02/2018)

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.

May 24, 2018 in Tableau by ghost
• 1,790 points
483 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

@Ghost, 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?

EDIT/UPDATE

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

answered May 24, 2018 by Atul
• 10,220 points

Related Questions In Tableau

0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22 in Tableau by Cherukuri
• 15,820 points
29 views
+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,510 points
150 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
824 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
679 views
0 votes
1 answer

How interactive graphs are generated in Tableau?

Lot of back end code is shared ...READ MORE

answered Apr 13, 2018 in Tableau by xyz
• 1,550 points
27 views
0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,220 points
30 views
0 votes
1 answer
+1 vote
1 answer
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,220 points
1,171 views
0 votes
1 answer

Creating a dual axis chart with same measure in Tableau

Yes, this is possible. Drop the measure in ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,220 points
745 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.