sum of occurrences from multiple columns

0 votes
How to sum of occurrences from multiple columns?
Apr 24 in Tableau by Preeti
12 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 24 by Cherukuri
• 19,950 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 17, 2018 in Tableau by Atul
• 5,530 points
155 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 Atul
• 5,530 points
35 views
0 votes
1 answer

How can I remove { } from columns in Tableau?

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

answered Aug 9, 2018 in Tableau by Atul
• 10,240 points
41 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
51 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
1,587 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,240 points
61 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 in Tableau by Cherukuri
• 19,950 points
51 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 in Tableau by Cherukuri
• 19,950 points
324 views