Make Pivot table display first day of week when graphing by week

joebenz · 2025-07-11T01:04:28+00:00

There was an error rendering this rich post.

I'm hoping to change the display for these weeks to be the date of the first day of the week (for example, July 7, 2025 for this week). How would I be able to format this?

Find more posts tagged with

Accepted answers

All comments

GrantSmith

You can get the first day of the week using a beast mode:

-- Description: Get the first day of the week
-- This is done by subtracting the day number (1-7) from the given date.
-- 5 (Thursday) - (5-1) days => 5 - 4 = 1 (Sunday)
DATE_SUB(`dt`, INTERVAL (DAYOFWEEK(`dt`) - 1) DAY)

You can find other helpful formulas I've written about here:

https://community-forums.domo.com/main/discussion/52687/domo-ideas-exchange-beast-modes-first-last-days-of-the-month-week

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of