13 periods in a year

Danielle Howes shared this question 2 years ago
Answered

Hi there,


Is there a way of configuring 13 periods in a year?

These periods are 4 weekly and start from a moving financial year start date.


For example; Period 1 (28 Feb - 27 Mar), Period 2 (28 Mar - 24 Apr), Period 3 (25 Apr - 22 May) ... Period 13 (30 Jan - 26 Feb).


Cheers,

Dani

Comments (3)

photo
1

Hi Dani,


Unfortunately there is no easy way to do this from within the UI. The best solution here will be to create this as a new column in your data source, or as a date reference table (a separate table with only date values: date, period) that you can then join into date values. This will allow you to extend this format multiple years into the future so the foundation does not need updating.


How are you planning to use this? Does this solution fit with your needs?


Regards,

Nathan

photo
1

Ah ok, that makes sense; that will be something that we need to maintain which is the downside!


We have users who report on a 13 period/month year, and the report users do not know the period 'dates', just period 1, 2, 3 etc. So it's something we need to define first, ie in a new view.


I'll let you know how we get on.


Cheers!!

photo
1

Hi Danielle,


That sounds like a good approach. sorry for the inconvenience, and let me know if there is anything I can help with in the meantime!


Regards,

Nathan