sum of occurrences from multiple columns

0 votes
How to sum of occurrences from multiple columns?
Apr 24 in Tableau by Preeti
15 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
• 26,020 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
238 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
39 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
55 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
82 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,829 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
77 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
• 26,020 points
58 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
• 26,020 points
500 views