Weekdays only in "Logged hours by users in current week" report


I’m using the “Logged hours by users in current week” week report available on the EazyBI Demo
but I would like to have only week days displayed, not the weekends.
I can’t use “Hide Empty” function because my week ends are not empty.

Is there a way to do this?


Hi @Marilou,

You might add the dimension “Week Day” to report pages to filter working days only and select the option to hide empty columns. This is a straightforward solution:

The alternative solution is to create new calculated members in the Time dimension that woudl group dates of a specific period excluding weekends. For example, expression to group days of previous week from Monday till Friday may look like this:

  --set of days between specified dates
    --previous week start date
    --relative date of previous friday
    "last friday")

More details on calculated members in Time dimension and relative dates are here:

Zane / support@eazyBI.com