We have a need to do some analysis of our business done on Saturdays. To this end, we’d like to have some favorites setup that compare sales just across Saturdays. I can’t see an obvious way I could get to a Saturday using offset or special dates. So I had the thought of creating a custom Period Type just containing Saturdays.
The issue I’m running in to, is apparently a Period Type must contain todays date in one of the periods, otherwise it won’t work. So I’m unable to create periods with just Saturdays.
I assume this is by design and not a bug?
Any thoughts on another way to accomplish my original goal of analyzing Saturday sales? (Without having to hard code and change dates each week.)
(Below screenshot shows behavior when current date is not contained in a period.)