When to use Bump Charts in Tableau

Bump Charts

  • When to use Bump Charts:
  • Bump Charts helps us to assign Ranks to various Dimensions across the Time series. Here, let’s find the Ranks of each individual Region in each cumulative Month. Database used is Sample Super Store.
  • Pull Month (Order date) (cumulative) onto Columns and Region on Colors on Marks card.
  • Create a Calculated Field, name it Rank and give the formula as Index().


  • Right Click on the Rank, Convert it from Continuous to Discrete.
  • Pull the Rank onto Rows.
  • Change the Mark type from Box to Line. We can see 12 Ranks now as there are 12 months.
  • Click on ‘Ranks’ on the rows, Go to ‘Edit Table Calculations’. In Compute Using, Select Specific Dimensions.  Select Month of Order date, Region. In ‘At the level’, select ‘Region’, at ‘Restarting Every’ Select ‘Month of Order date’, at ‘Sort Order’ choose Custom, Select ‘Profit’, aggregation to ‘Sum’, and Sort order ‘Descending’.
  • This gives the Ranks such that, in which particular Month, which Region holds the number 1-4 Ranks.





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