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 25, 2018 in Tableau by ghost
• 1,790 points
7,681 views

1 answer to this question.

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 25, 2018 by Atul
• 10,240 points
I want to merge the cells of  Rows which are result of an aggregate function - where value is same for these cells.. Could you please help

WINDOW_MAX(SUM([Sales])) -- (computed using Pane down)

Can you provide more information on your question? (dimension/column names)

You want to group rows that have same WINDOW_MAX(SUM([Sales])) value. Am I right?

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, 2019 in Tableau by Cherukuri
• 33,030 points
3,598 views
+2 votes
1 answer
+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 4, 2018 in Tableau by ffdfd
• 5,550 points
4,328 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
15,357 views
0 votes
1 answer

How interactive graphs are generated in Tableau?

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

answered Apr 14, 2018 in Tableau by xyz
• 1,560 points
857 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 29, 2018 in Tableau by Atul
• 10,240 points
1,017 views
0 votes
1 answer
0 votes
1 answer

R vs Tableau data visualization.

@Yash, This is a requirement based question. ...READ MORE

answered Oct 28, 2019 in Data Analytics by anonymous
• 33,030 points
8,549 views
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,240 points
9,929 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 29, 2018 in Tableau by Atul
• 10,240 points
8,779 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP