Skip to main content
GroupsMumbai
Featured group

Mumbai

Tableau User Group board | Mumbai (India)
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
Jun 26, 2024, 10:17 AM
Sort angles in a Pie Chart with Others at the end

Hi,

I am creating a Pie chart showing Top 5 Manufacturers and rest all combined into 'Others'. So Mfr 1,2,3,4,5 and Others.

I want to sort the Top 5 Mfr in descending order of Sales and Others at the end.

3 answers
  1. Steve Wood (RealNZ)
    Jun 26, 2024, 10:37 AM

    Hi @Ashish Nandivadekar​ 

    Like this?

    Hi @Ashish Nandivadekar​ Like this?I've created a Top 5 set based on State:Now we can create a calc to show State name, orI've created a Top 5 set based on State:

    image.pngNow we can create a calc to show State name, or "Other" when not top 5...

    IF [Top 5 States] THEN [State] ELSE 'Other' END

    And another that only returns sales for top 5. Top 5 State Sales or 0. we'll use this for sorting...

    IF [Top 5 States] THEN [Sales] ELSE 0 END

    The sorting:

    image.pngWorkbook attached so you can take a look!

    Let me know if it helps.

    Ta, Steve

    top-5-other-sort.twbx
Write an answer...
0/9000
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
May 24, 2017, 11:52 AM
HOW DO I CREATE SET OF DIMENSION ON BEHALF OF AGGREGATE PERCENTAGE OF TOTAL LIKE 80-20 RATIO

I have a sample dataset with one measure and one dimension , first get percentage of total of dimension. I want bar chart in output where only that dimension's records shows whose are in 80% of total and rest are shows in other.

 

HOW DO I CREATE SET OF DIMENSION ON BEHALF OF AGGREGATE PERCENTAGE OF TOTAL LIKE 80-20 RATIO

 

I want Only one line for other

 

pastedImage_1.png

 

Please help me out.

null

80-20.xlsx
2 answers
  1. Sandip Sharma
    May 24, 2017, 1:09 PM

    Hi Avinash,

     

    Trust you are looking for this output

Write an answer...
0/9000
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
Nov 5, 2014, 9:07 AM
Need help in getting right average of data.

Please see attached file for exact data structure and sample data.

 

Help will be greatly appreciated.

SampleData.jpg
7 answers
Write an answer...
0/9000
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
Mar 15, 2014, 9:45 AM
Need Help

Is it possible to create button and assign event on that in Tableau? I have to create a button and by clicking on that button i need to display top 10 sales data for a region........Please help

13 answers
Write an answer...
0/9000
Viraj Bhargave (Lead Analyst at Dentsu Global Services)
Nov 7, 2024, 2:11 PM

Hello  Everyone,

 

The Mumbai Tableau User Group is back with yet another event with some interesting topics.

Join and RSVP for the virtual event happening on December 6th at 7:00 PM IST.

RSVP here - https://usergroups.tableau.com/e/mpv6th/

 

usergroups.tableau.com

Write a comment...
0/9000
Tableau Community Forums Member (Inactive) (Member of the Tableau Community Forums at Salesforce)
Sep 17, 2024, 8:12 AM
Dynamic Data source Filter

I only want to pull needed data from the data source into Tableau.

For ex, if I initially have only 2 category values on my Dashboard Category Filter, then only those 2 category data should be pulled from the data source and later when I select only 1 category value then only that 1 category data should be pulled from data source into tableau. Dashboard filters should work directly on data source and pull only request data.

3 answers
  1. Steve Martin (Turning Point)
    Oct 2, 2024, 5:11 PM

    I'm a bit lost on this one @rhut parekh​ as this is exactly how data source filtering works, unless of course you plan on defining a new data source from the result of the filter, in which case, Context Filters will probably help here. Simply right-mouse your filter, and select Add to context. And if this source is to be used across each of the vizzes using the same source, set the filter on all pages.

     

    @Vibhu Sharma​ this is just normal querying and filtering. Have you experienced degraded performance from attempting to implement this?

     

    Steve

Write an answer...
0/9000
Viraj Bhargave (Lead Analyst at Dentsu Global Services)
Sep 9, 2024, 6:00 AM

Join us on September 26th for two interesting topics

  • Formatting dates by 3x Tableau Social Ambassador Vani Agarwal
  • Discover different and innovative ways to visualize time beyond the traditional line chart with Sr. Data Evangelist Andy Cotgreave.

RSVP here: https://usergroups.tableau.com/events/details/tableau-mumbai-tableau-user-group-presents-mumbaitug-sep2024-formatting-dates-and-how-to-think-beyond-line-chart-to-visualize-time/

usergroups.tableau.com

Write a comment...
0/9000
Ciara Brennan
Jul 10, 2024, 2:36 PM

💫 2024 Tableau Ambassador nominations & applications are open ðŸ’«

  • Check out the Blog (courtesy of @Britt Staniar​ & Pooja Khanna)
  • Closing date is July-11-2024
  • The form for applications & nominations is HERE

💫 2024 Tableau Ambassador nominations & applications are open 💫Check out the Blog (courtesy of @Britt Staniar​ & Pooja Khanna)Closing date is July-11-2024The form for applications & nominations is H

Write a comment...
0/9000
Ciara Brennan
Feb 16, 2024, 2:17 PM

Mumbai Tableau User Group | Feb-22-2024

RSVP here

Mumbai Tableau User Group | Feb-22-2024RSVP here

Write a comment...
0/9000