Loading

How to Display Week Number by Month

Date de publication: Apr 13, 2024
Tâche

How to display week number by month. By default week number is displayed by year. 
 

Étapes
The following steps are displayed in the attached workbook called "week_sample.twbx" found in the upper right hand corner of this page. A fixed Level of Detail (LOD) expression is used.

  1. Create a [Week-min] calculation field as shown below: { FIXED MONTH([Order Date]):MIN(DATEPART('week',[Order Date]))}

  2. Create a [Week-updated] calculation field as shown below CASE DATEPART('week',[Order Date]) WHEN [Week-min] THEN "Week 1" WHEN [Week-min]+1 THEN "Week 2" WHEN [Week-min]+2 THEN "Week 3" WHEN [Week-min]+3 THEN "Week 4" WHEN [Week-min]+4 THEN "Week 5" WHEN [Week-min]+5 THEN "Week 6" END
Note: The attached workbook was built in Tableau Desktop 2019.3.0.
Ressources supplémentaires

Days in week per month
Numéro d’article de la base de connaissances

001453773

Pièces jointes

week_sample.twbx

1197 KB

 
Chargement
Salesforce Help | Article