KNOWLEDGE BASE

Display Dates By Half Year (Semester)


Published: 20 Nov 2013
Last Modified Date: 07 Dec 2015

Question

How to create a group for the first or second two half of a year.

Environment

Tableau Desktop

Answer

Group the months or quarters using a calculated field. The following instructions can be reviewed in the workbook attached below: 
  1. In Tableau Desktop, click Analysis.
  2. Select Create Calculated Field.
  3. In the dialog box enter the following formula:
    IF DATEPART('quarter', [Date]) < 3 THEN 'Semester 1' ELSE 'Semester 2' END
  4. Name the calculation and press OK.
  5. The new field will appear under Dimensions.

Additional Information

It is possible to create more complex date calculations to narrow down to a specific range of dates, instead of using the default 'quarter'. To learn more about Date calculations please refer to the On Demand training video: Date Calculations 
 
And for a more descriptive article on the Date Functions available in Tableau Desktop please refer to the product guide here: Date Functions.
 
Did this article resolve the issue?