How to put week in time hierarchy

Questions & Answers
1

Hi,
Today the time dimension have this hierarchy Year, Quarter, Month and Day.

Is there any way to have Year, Quarter, Month, Week, and Day?

Example My account start in day 1 from jan 2021. Week 14 have data from two months

  • 2021
    • Q1 2021
      • Jan 2021
        • week 1
        • week 2
        • week 3
        • week 4
        • week 5
      • Feb2021
        • week 6
        • week 7
        • week 8
        • week 9
      • Mar 2021
        • week 10
        • week 11
        • week 12
        • week 13
        • week 14
    • Q2 2021
      • Apr 2021
        • week 14
        • week 15
        • week 16
        • week 17
        • week 18

Best Regards

2

Hi @granadeiro

Yes, indeed, the standard Time dimension Weekly hierarchy does not contain months and quarters, as the same week might belong to two months/quarters.
We have some improvement ideas here, though.

I would suggest defining and using custom calculated members in the Time dimension where you can pull weeks for the current month, previous month, or other periods.

You can check some example formulas for this in our demo account. For example, this example report. We are pulling weeks for the specified period, either explicitly selected period, or by current month, previous month.

Ilze, support@eazybi.com

3

Hi @granadeiro ,
I wanted to let you know that we have released eazyBI version 7.0 recently. We included in this version an option to define custom time hierarchies. See the documentation for different examples: Custom time hierarchies

Please see a list of all changes: Changelog - eazyBI for Jira.

best,
Gerda // support@eazybi.com