Display Dates By Half Year (Semester)

Published: 20 Nov 2013
Last Modified Date: 16 Jan 2019


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


Tableau Desktop


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.
Did this article resolve the issue?