Smart histograms are visualizations that summarize how many data points occur in the bins Tableau creates. In this video, learn how to summarize data using a smart histogram.
- [Instructor] Histogram summarize data in a vertical bar chart where each bar represents the count of data points that occur within a given value range. This is also called a frequency chart. Tableau creates bins based on its own analysis of the data but if you want to, you can edit the bin size. I'll demonstrate how to do that in this movie. My sample file is 09_07 SmartHistogram and you can find that in the chapter nine folder of the exercise files collection. I call this file SmartHistogram because that's the technical name for this particular feature within Tableau but what you're really doing is specifying the size of the bins that you want. To do that, you go over to the data panel. And then under dimensions, you'll see that there is an Order Total (bin) pill. That pill appears after you define a histogram and it is used on the columns shelf to divide the values within your histogram. If you want to edit the values used to create the bins, then go to the data tab under Dimensions, right click the Order Total (bin) in this case and then click edit. In here, you see that you can edit your bins for order total. From here, we can see that Tableau created bins that are $2,470 wide. Let's say we want to break that down so it's a little bit more fine grain and take it down to 1,000. So I will change the size of the bins from 2,470 to 1,000. And if I look at the range of values with a minimum of five, maximum of 83,885, and a difference or a range of 83,880, then 1,000 will break us into, it looks like 84 bins but it will give us a lot more detail on the values especially toward the left end where we have a lot of sales in the zero to 2,470 range. So I'll go ahead and click Okay and we have the sales broken down in more detail. And we can see, as we expected, that we have a few very small sales to wholesale customers, but we also have a lot of sales in the 1,000 to 2,000 range and the 2,000 to 3,000 range. So what we're looking at is a big spike around $3,000 or $2,500 and then it goes down significantly after that with a very low count of orders ranging up to $27,000 but for the most part were clustered to the left of the graph. I think that this version of the histogram with the narrower bins provides a lot more actionable information about Red30 Tech's sales.
- Explain where a user would navigate to seek specific help in Tableau.
- Determine the best approach for using Excel in Tableau.
- Interpret how to use the features and functions of Tableau when creating charts.
- Describe how best to manage data in a worksheet or visualization.
- Explain how to create a selection filter for certain values.
- Explain how to manage data for different chart formats.
Skill Level Beginner
1. Introducing Tableau
2. Managing Data Sources and Visualizations
3. Managing Tableau Worksheets and Workbooks
4. Creating Custom Calculations and Fields
5. Analyzing Data
6. Sorting and Filtering Tableau Data
7. Defining Groups and Sets
8. Creating and Pivoting Crosstabs
9. Creating Basic Visualizations
10. Formatting Tableau Visualizations
11. Annotating and Formatting Visualizations
12. Mapping Geographic Data
13. Creating Dashboards and Actions
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.