Need to group customers, based on %

0 votes
How to dynamically keep groups that would change as per profit? i.e, if profit is below 10% of total, then group1 if profit>20% then group3 else group2.
May 20 in Tableau by karthick
17 views

1 answer to this question.

0 votes
Hi Karthick, You calculative field to form dynamic groups.

Create a calculative group as

IF [Profit%]<10% THEN "Group1"

ElSEIF  [Profit%]>20% THEN "Group3"

ELSE "Group2"

END

The above calculative field would create groups as per profit% and add fields in respective groups. The groups created by calculative groups are dynamic.

Hope it helps.
answered May 20 by anonymous
• 19,510 points

Related Questions In Tableau

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,575 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
3,637 views
+1 vote
1 answer

How to add filter on different sheets based on clicks?

Go to Actions… (if you're on a dashboard, you ...READ MORE

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

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
42 views
0 votes
1 answer

How to determine average per event by year?

Hi Roshan, Create a new calculated field (use ...READ MORE

answered Sep 25, 2018 in Tableau by Machdata
• 340 points
50 views
0 votes
0 answers

Calculating count average from averages

I've a calculated field in Tableau which ...READ MORE

May 28, 2018 in Tableau by Mahima Choudhary
21 views
0 votes
1 answer
0 votes
1 answer

How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
78 views
0 votes
1 answer

Filter Measure Based on Different Variables of the Same Dimension

Hi Nithin, I used calculated fields. You can use ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 19,510 points
22 views
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,510 points
51 views