Dual Axis Graph

[JCovelli]

Hello, is it possible to show both MONTH and WEKLY time intervals on a dual axis, or even on the same axis in EAZYBI?

[zane.baranovska]

Hi @JCovelli,

Monthly and weekly hierarchies are separate as the beginning and end of each week does not match the beginning and end of the month. And in a report, you may use only one hierarchy at the time.

An alternative, in the weekly hierarchy, is to create calculated members for each “month with weeks” and group weeks by week numbers or date of the first day of the week.
Check out this community post where is described a similar use case:

Filter Current Month by Weeks

Hi @briantaylor, Currently, eazyBI does not support monthly hierarchy represented by a set of weeks as one week might be split by two months. For this reason, we have two separate hierarchies, one to display dates by month and another by weeks. In eazyBI backlog, we have a task to allow creating custom hierarchies in Time dimension. But we are still looking for the best solution on how to support this. My colleague or I will post a notification in this conversation when the feature is released…

Best,
Zane / support@eazyBI.com