Last Modified Date: 09 Jan 2019
Environment
Tableau DesktopAnswer
Option 1: Create bins at one date level
Use this method to create bins within one date level. For example, creating bins for every 2 days
The below instructions create a view showing flight delays by day of month, broken down into 2-day increments, and are based on the attached packaged workbook DateInterval.twbx.
- Select Analysis > Create Calculated Field.
- Name the field Flight Delays, enter the following calculation, then click OK:
DATEPART('day', [Flight Date])
- in the Measures pane, right-click Flight Delays and select Create Bins.
- Name the field 2 Day Intervals, enter 2 for Size of bins, then click OK.
- Drag 2 Day intervals to Columns.
- Drag Arr Delay to Rows.
- Right-click Arr Delay on Rows and select Measure > Average.
- Place Dest State on Color.
Additional Information
To view these steps in action, see the video below.Note: the video has no sound.
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