Loading

Display Dates By Half Year on a Semester Basis

Udgivelsesdato: Apr 21, 2025
Opgave

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

Trin
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.
Vidensartikelnummer

001458194

Vedhæftede filer

date_by_semester.twbx

403 KB

 
Indlæser
Salesforce Help | Article