Showing absolute and percentage values in Tableau

0 votes

In the form of a matrix, I want to present both absolute and percentage values in one view. In the screenshot below, I'm attempting to create a new column that displays data as percentages of the total.

image

The data is:

image

Please suggest.

Apr 4 in Tableau by Vaani
• 7,020 points
329 views

1 answer to this question.

0 votes

I recreated a data like yours,

enter image description here

Follow these steps

  • Add slide on rows
  • Add number of records in text on marks card
  • Add table calculation on this field -> percent of total. The view will look like this

enter image description here

  • Notice a small triangle in 'no of records' field. That indicates that it is table calculation

  • Add number of records field once again to text. (Tip: Double click the field number of records to add it to view directly)

enter image description here

  • Reorder as you like

enter image description here

or with totals

enter image description here

answered Apr 5 by Neha
• 8,940 points

Related Questions In Tableau

0 votes
1 answer

Rank measure values and show percentage of measures in Tableau

Hi Sindhu, 1. First create a table with ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,050 points
3,133 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,230 points
10,467 views
0 votes
1 answer

Search values in a sheet for a field and display in tableau

Hi Sindhu, Follow below steps: 1. Create a parameter ...READ MORE

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,050 points
387 views
0 votes
0 answers

Tableau not showing all data in box and whisker plot

In tableau, I'm trying to make a ...READ MORE

Apr 13 in Tableau by Neha
• 8,940 points
175 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
121 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
117 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
118 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 7,020 points
163 views
0 votes
1 answer
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