When to use Histograms

HISTOGRAMS
  • Histograms is a chart where we can show data in chunks. Data is divided into bins.  Example in healthcare, we can have patients with their age in bins and analyze the data using histograms such that we can find which group of patients are visited more often in that hospital and in what time of day.
  • Note: bins can only be created on Measures. It can’t be created on measures.
  • Example: Create a Bins on Sales with a bin size of 1000. Right Click on Sales, Select Create, Select Bins. Pull Sales(bin) onto Columns and Sum(Sales) onto rows.




  • We can analyze the data here, the first Bin(0-1000)sales are making 1.3M sales, next bin(1000-2000) are making 450k Sales. The Bins with 14kto 16k doesn’t have sales at all.

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