-
1. Re: Top N Analysis basis more than one parameter
kumar bharat Jul 17, 2018 4:07 AM (in response to Ruchika Bhandari)Hi Ruchika,
Please check this:
Create Sets for Top N and Others
Using a Top N Parameter to Filter a Table | Tableau Software
BR,
bharat
-
2. Re: Top N Analysis basis more than one parameter
Ruchika Bhandari Jul 17, 2018 5:26 AM (in response to kumar bharat)Dear Kumar,
Thank you for your reply.
I followed the same steps as mentioned in the articles shared by you. However, I want to apply one more parameter to the analysis. I want state-wise top 'N' customers. I am attaching the link to the workbook for your reference. Can you please help with this?
-
3. Re: Top N Analysis basis more than one parameter
kumar bharat Jul 18, 2018 10:20 PM (in response to Ruchika Bhandari)Hi Ruchika,
I checked your dashboard but did not find the state coming in the data.state is missing in the data.
Dual Axis separate filter - same dimension
*** you can use LOD expressions
Top N with multiple dimensions displayed
BR,
bhara
-
4. Re: Top N Analysis basis more than one parameter
Ruchika Bhandari Jul 19, 2018 12:42 AM (in response to kumar bharat)Hi Kumar,
If you open my workbook you can see that I have created a 'State Parameter' and a calculated field 'Select State' basis this parameter. Though I have not added State Parameter card to the sheet but you can see that I have added the calculated field to the filter card. Even if we insert the Parameter card into the sheet and change the state, I am not getting the desired result. (i.e Contribution of top n customers to the sales vis-a-vis others contribution)
Further, I have gone through all the links shared by you. Below article, though rightly gives the top N customers view however it is not fulfilling my requirement. I don't want to show individual customer name and sales contribution. Rather I want to create two groups sales amount of the Top n customers and sales amount of remaining customers in a particular region for a particular period show both groups in the bar chart (like the screenshot I shared the original question).
Top N with multiple dimensions displayed
I hope I am able to clearly mention my requirement. In case, if it still not clear please feel free to ask.
-
5. Re: Top N Analysis basis more than one parameter
kumar bharat Jul 19, 2018 1:15 AM (in response to Ruchika Bhandari)Hi Ruchika,
You can create top n customers and other customers as others as two seperate groups.
check this
Create Sets for Top N and Others
Top N, with everyone else as "Other"
Dynamic Top N with "Others" Category as filter / time-series
Top N and Others + Nested Sorting
Create Sets for Top N and Others by Department
BR,
bharat