Custom Period Type must contain todays date?


#1

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.)

image


#2

Correct it’s by design.
To enable the use of offset periods, the offset is always from period containing today eg.
-1 is the previous period whether that be a quarter, week etc.

Another way to do this would be add a dimension of weekday, you could then select just Saturdays.
If you have access to DB designer a transform column with:
DATEPART(weekday,[INVOICE_DATE]) amend column name to suit, returns 1 for Sun 2 Mon Etc


#3

Thanks for the info. I ended up working around this by using a sync source for my time period. In this sync source, I’m using some SQL to dynamically return the current day, plus the past 52 Saturdays.

Now I can use a -1 offset to give me the last Saturday, and can even do a period comparison to compare a year’s worth of Saturdays.