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 in Tableau by Priyanka
28 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 by anonymous
• 21,150 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
123 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
144 views
0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
2,447 views
0 votes
1 answer

Counting number of elements in a comma seperated column in Tableau

If you have access to the database, ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,550 points
179 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,606 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
62 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 in Tableau by Cherukuri
• 21,150 points
47 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 in Tableau by Cherukuri
• 21,150 points
532 views