-
Calculating the SUNDAY start date of the week from Google Analytics' "WeekOfYear" Dimension
One task that I was faced with recently was trying to determine what the date of the SUNDAY start of a calendar week would be, given only the YEAR and the WEEK number. All of the YEAR(s) and the WEEK(s) would be obtained from Google Analytics as "YYYYmm". With the help of Joe Ehat of DOMO Technical Support, I came up with…
-
Period over Period card, Last 'n' weeks compared to 52/53 weeks ago = How to EXCLUDE current week?
I have a BigQuery dataset that updates daily, but is one day behind on purpose. Today is Monday, so the lastest data that I have is from Sunday. My company is working on a Mon-Sun fiscal calendar, and, yes, it IS optioned for our instance. I am creating a "Last 5 Weeks" grouped bar card, with comparison enabled to 52 weeks…
-
How to show week-by-week comparisons in grouped vertical bar cards where the weeks roll-over years?
When I got into work this morning, the Grouped Vertical Bar cards which I had built to show week-by-week comparisons of THIS year's values versus LAST year's values were all broken. The Beast Modes that I had created to differentiate by week were all malfunctioning because today is Wednesday, January 2, 2019, and the end…
