Combined set for dynamic selection of members in a set

0 votes
Hi, I want to show customers who are regular customers past n years and top N customers. I want to show customers using sets and combined set and allow user to choose customer as regular or irregular/regular and Top N customers. Can anyone help?
Jun 10, 2019 in Tableau by Priyanka
541 views

1 answer to this question.

0 votes

Hi Priyanka

Follow the below steps:

1. Create 2 sets for each of the requirement in your problem

   SET1 - Create Top N Customers 

   Right click on the cust - id and go to create and select set. I use N to provide through parameter.

       

     SET 2 - Regular and irregular customers

     Create 2 sets for indivisual year i.e current and previous year.

      

     Now create a combined set to show common/regular customers or irregular customers by comparing years.

2. Create a combined set with SET1 and SET2.

    Select both the sets and ten right click on the set and click on combined set.

    Now choose Type of set i,e both inclusive or exclusive or shared member set.

    Click ok. 

3.Now use the combined set to show dynamic selection.

Hope it helps you!

answered Jun 12, 2019 by anonymous
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

Dynamically set the value of a filter based on a parameter selection in use to swap sheets

Here's a simplified example of the calculated ...READ MORE

answered Apr 29 in Tableau by anonymous
• 1,380 points
1,807 views
0 votes
0 answers

Set difference: find distinct members for two groups in Tableau Desktop

In Tableau Desktop, how do I accomplish ...READ MORE

Apr 13, 2022 in Tableau by Neha
• 9,060 points
297 views
0 votes
0 answers

Set difference: find distinct members for two groups in Tableau Desktop

In Tableau Desktop, how do I accomplish ...READ MORE

Apr 14, 2022 in Tableau by Neha
• 9,060 points
281 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
9,492 views
+2 votes
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
1,339 views
+2 votes
1 answer
0 votes
1 answer

How to show outliers for a given set of points.

Hi Anshuli, Follow below steps: 1. Create a line ...READ MORE

answered Apr 17, 2019 in Tableau by Cherukuri
• 33,030 points
691 views
0 votes
2 answers

How can I add text in the centre of a Donut Chart ?

Hi, You can read this for creating a donut ...READ MORE

answered Apr 4, 2019 in Tableau by Cherukuri
• 33,030 points
11,605 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP