How do I display the start date of the week instead of the week number?

Display the week start date instead of the week number

To change how attributes appear, create a custom attribute:

In the report builder, click the Calculations icon ( ) on the right sidebar

Click Standard calculated attribute, which opens the formula editor

Paste the custom attribute below into the formula editor

DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Date]),"YYYY-MM-dd")

Click Save

Add the custom attribute to the report. Replace START_OF_WEEK_MONDAY with START_OF_WEEK_SUNDAY or START_OF_WEEK_SATURDAY, whichever you want your week to start in.

The calculations for the aggregators MED and AVG produce skewed results because they calculate from individual daily values. This creates seven data points for each day in the week, rather than a single value across all tickets throughout the week.

Warning: If your Explore account isn't in English, you may experience a syntax error when you copy and paste the sample formula. For a workaround, see How can I convert formulas from English into another language?