Last Modified Date: 09 Jan 2019
Environment
Tableau DesktopAnswer
The following instructions create a histogram using the sum of sales per day.
- Select Analysis > Create Calculated Field.
- In the calculated field dialog box:
- Name the calculated field. In this example, the calculated field is named Day Date.
- In the formula field, create a calculation similar to the following:
DATETRUNC('day', [Order Date])
- Click OK.
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box:
- Name the calculated field. In this example, the calculated field is named Sales per Day.
- In the formula field, create a calculation similar to the following:
{FIXED [Day Date] : SUM([Sales])}
- Click OK.
- Right-click on Sales per Day in the data pane and select Create > Bins….
- In the Create Bins dialog:
- Name the Bins field as desired.
- Enter the desired bin size.
- Click OK.
- Drag Sales per Day (bin) to Columns.
- Drag SUM(Sales) to Rows.
- Optional: Right-click on the bin labels on the view and select Edit Alias….
- Enter the desired name for the bin label.
- Click OK.
Additional Information
For more information about Histograms, see Build a Histogram and Create Bins from a Continuous Measure in the Online Help documentation.Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials