I’m pretty upset that there is no week option when...
# suiteanalyticss
suitemike
02/28/2020, 7:50 PMI’m pretty upset that there is no week option when selecting a date hierarchy in new analytics
a
Aria Ghahari
03/02/2020, 9:52 PMYou can use TRUNC to get it down to weeks
s
suitemike
03/02/2020, 9:54 PMIn the pivot table view?
a
Aria Ghahari
03/02/2020, 9:58 PMYes. I did it last year but can't remember the formula. Pulling a Fermat here, I know.
Aria Ghahari
03/02/2020, 9:58 PMGive me some time, I might be able to find it.
Aria Ghahari
03/02/2020, 10:23 PMmessage has been deleted
Aria Ghahari
03/02/2020, 10:24 PMThis will bring all dates to the first of the week.
👍🏼 1
2 Views