sum of occurrences from multiple columns

0 votes
How to sum of occurrences from multiple columns?
Apr 25, 2019 in Tableau by Preeti
148 views

1 answer to this question.

0 votes
Hi Pretti,

You can find the sum of occurrences from 2 columns by using pivot.

Follow the below steps:

1. Add new data source (i.e the same source as before )

2. Now select the columns that you want to use to perform some.

3. Then click on the Drop-down button and click on the pivot.

4. Now click on sheet. Now place the pivot column and Drag the Number of records over the pivot field.

5. Now the occurrence among fields is shown in SUM(Number of fields) over the pivoted field (i.e multiple columns selected to count the sum of occurrences).

Hope it helps you.
answered Apr 25, 2019 by Cherukuri
• 33,010 points

Related Questions In Tableau

0 votes
1 answer

Aggregating from multiple columns in Tableau

You can use Tableau’s inbuilt pivot method ...READ MORE

answered Aug 18, 2018 in Tableau by sdfg
• 5,550 points
4,792 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by sdfg
• 5,550 points
454 views
0 votes
1 answer

How can I remove { } from columns in Tableau?

Create the following calculated field and use ...READ MORE

answered Aug 10, 2018 in Tableau by Atul
• 10,230 points
372 views
0 votes
1 answer

Sum of previous two months sales where the current month is entered by the user.

It can be achieved easily by creating ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
3,072 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,230 points
8,146 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
832 views
+2 votes
1 answer
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,010 points
1,100 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,010 points
12,802 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP