Show only months in time dimension when used in rows

walterdp · December 31, 2024, 3:29pm

Hi all,

I need to show months only in rows, not year, as I’m comparing issues with previous year and it could be confusing to see
This is how it looks like now

I need to show it like this:

Any ideas?

Thanks,

W

martins.vanags · January 7, 2025, 3:00pm

Hi @walterdp

If you want to replace month label names with shorter - you can try exploring custom time hierarchies:
https://docs.eazybi.com/eazybi/analyze-and-visualize/custom-time-hierarchies

If you want to group all first months from all years, then the approach could be creating a new calcualted member in the “Time” dimension and calling it “Jan” where you group all months that are January months. Similar for each of the months.
Then select all 12 members in the reports.

I used this code in my screenshots (for Jan)

Aggregate(
  Filter(
    [Time].[Month].Members,
    [Time].CurrentMember.key = 1 
  )
)

A similar code would be for Feb months.

Aggregate(
  Filter(
    [Time].[Month].Members,
    [Time].CurrentMember.key = 2
  )
)

Martins / eazyBI