Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have created the following chart with a dimension ranging per week. I'm trying to see if there's a way for the range to only show one day (week of: 12/26, 1/2, etc) instead of 12/26-1/1
How do you define your current dimension?
=Dual(WeekStart(APP_LOGIN_DATE)&' - '&WeekEnd(APP_LOGIN_DATE),WeekStart(APP_LOGIN_DATE))
How about this?
=Date(WeekStart(APP_LOGIN_DATE), 'MM/DD')
That worked, thank you!