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
23 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
• 31,840 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
2,199 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
5,644 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
61 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
63 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
61 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
29 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
133 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
• 31,840 points
34 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
• 31,840 points
76 views