DONUT CHART in Tableau

DONUT CHART


  • ·   The first question we get is Why use a Donut Chart, while you can simply use a pie chart. Well, Pie Chart only works for one measure value. When you want to represent two measure values in a single view, its better we use a donut Chart.
  • ·   In this example, the donut Chart helps us to find the ‘profit ratio’ made by each ‘category’ in different ‘Regions’. The database used is Sample SuperStore.
  • ·   Lets use a simple trick to create Donut Chart, create a calculated field, name it ‘Donut’ and     give 0(zero).
  • ·   Pull this formula Donut (Sum(Donut)) on to the Columns twice.
  • ·   Now you have two Marks cards, with Sum(Donut) and Sum(Donut)2.
  • ·   Adjust the sheet to ‘Fit Height’.
  • ·   In the columns, right click on second Sum(Donut), select Dual axis.
  • ·   In the second Marks card, Adjust the color to white and increase the size.


  •  ·  In the first Marks card, Pull Category onto color, you will observe the three colors are equally divided. Now pull Profit Ratio onto angle, this gives the profit ratio of each category. Then Pull Category and profit Ratio onto labels.
  •     In the second Marks Card, pull Sales onto label and format it such that it comes to center of the circle.
  •     Now Pull Region onto columns. You can see the profit ratio made by each category in different Region.
  •     Format the chart by hiding the headers, sorting the Region and making changes to tooltips, labels, legends, title, fonts. 


Comments

Post a Comment

Popular posts from this blog

Types of Sorts

Image
Sorts Sorts are of different types, 1.      Simple Sort 2.      Complex sorts 3.      Advanced Sort using Calculated field 1.      Simple Sort ·        Pull Region onto Columns, Sub-Category onto Rows and Sales on the Text on Marks card. Database used is Sample Superstore and Tableau 10.3. ·        We can find the highest ‘Sales’ in each ‘Region’ by clicking on the ‘Sort’ Button beside each Region. Here the Sub-category ‘Phones’ has the ‘highest Sales’ in ‘East Region’. ·        Note: The default sort type is Descending. ·        We can sort the Sub-Category too, it will be ascending and Descending according to alphabetical order. ·        We can also sort the Sales ‘Row-Wise’, this give the sales from high to low Sales for that particular Sub-Category. ·        Now Pull Category onto Rows, Click on the Category, goto Sort, we can see the window as shown in the below pic. We have options for Sort Order Ascending, Descending. ·        Sort By : Da
Read more

HOW TO USE RANKS IN REAL TIME SCENARIOS IN TABLEAU

Image
HOW TO USE RANKS IN REAL TIME SCENARIOS   In this example, let’s find the Top 3 selling Sub-Categories in each State. We would be using Sample superstore database and Tableau 10.3. Pull Sales onto columns and State and Sub-category onto rows.   Create a Calculated field, call it ‘Rank’ and give ‘Index ()’. Index returns the row position. Pull the Rank onto Rows, in between State and Sub-Category. Change it from ‘Continuous’ to ‘Discrete’. You can find the Rank created, giving 1, 2,3 ... 656 across the whole table starting from Alabama to Wyoming.   Let’s change the Rank such that it gives Rank Only State wise. It should start giving Ranks from 1, 2,3...n in each state.   Right click on Rank, go to Compute Using, Choose the Option ‘Pane (Down)’ instead of ‘Table(Down)’. This action helps restart Rank (1 to n) in every State.       Now, Let’s give the Ranks 1 to N to Sub-Categories such that the highest sales holds 1 and next highest 2 ..  to do this, Right click on Rank, go
Read more
Tableau Desktop Vs Tableau Server Tableau Desktop:-   All your development is done here. From creating reports, charts,  formatting them, putting them together as a dashboard all the work is done on Tableau Desktop. 1. Data Source Connection 2. Extractions 3. Analysis Process 4. Statistical Analytics 5. Visual Analytics 6.Designing, Creating, Publishing and Scheduling Tableau Server:-   The dashboards you create are shared with other users using Tableau Server. When you upload(publish) a Dashboard to Tableau Server from Tableau Desktop, other users can access those Dashboards by logging on Tableau Server. 1. Data Source, Sheets/Workbook Management (Content) 2. User Management 3. Performance Management (Load balancing, Server Management) 4. Scheduling Activities What is the difference between core-based and user-based licenses 1 User-Based Server License:    If your Server Software license is designated as User-Based, the Named Author
Read more