KNOWLEDGE BASE

Display Dates By Half Year (Semester)


Published: 20 Nov 2013
Last modified date: 15 Jan 2024

Question

How to create a group for the first or second 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.
Did this article resolve the issue?