Category
Data Sources
Product Version
7.3
13 periods in a year
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
The same question
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
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
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!!
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!!
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
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
Replies have been locked on this page!