My query displays the week of the year, but I want to see the date that the week starts with instead. How can I do that?
To change the way attributes display, you need to create a custom attribute. To accomplish this:
- In Query Builder, click the calculations icon () on the right sidebar.
- Click Standard calculated attribute.
You will be redirected to the Formula editor (see Navigating the Formula editor).
- Paste the following custom attribute into Formula editor.
DATE_FORMAT(START_OF_WEEK_ISO([Ticket created - Date]),"YYYY-MM-dd")
- Click Save.
- Add the newly created attribute to the query.
When using this calculated attribute, the calculations for MED and AVG are skewed because they are calculated from the values for each day individually, which means seven data points (each for a day in the week), rather than from the values across all tickets throughout the week.