Last Modified Date: 13 Apr 2017
AnswerThe below instructions create a view showing flight delays by day of month, broken down into 5-day increments, and are based on the attached packaged workbook UsingCustomDateLevels.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 5 Day Intervals, enter 5 for Size of bins, then click OK.
- Drag 5 Day intervals to Columns.
- Drag Arrival Delays to Rows.
- Right-click Arrival Delays on Rows and select Measure > Average.
- Place Destination City on Color.
Note: You can use this technique to look at a variety of custom date and time levels by specifying a different DATEPART in the calculation. For example, if you wanted to look at 15-minute increments, you would replace "day" with "minute" in the formula.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials