Workdays in Rows

Questions & Answers
1

Hi Guys,

It’s possible to create a mensuares that in report shows only the workdays?

See the picture below, with Set 4th, Set 6th , Set 8th…
Set 8th isn’t a work day and for us is not important.

image
image.png1048×386 15.6 KB

2

Hi,

You could create a new calculated member in “Measures” dimension to filter only for workdays
Later you could filter your report by this column and finally unselect the column (filter will remain)

Try this code for the new calculated measure:

DateDiffWorkDays(
      [Time].CurrentHierarchyMember.StartDate,
      [Time].CurrentHierarchyMember.NextStartDate
    )

Martins / eazyBI support

3

Hi Martins,

Thank you so much for your help. I tried to user your measure code, but doesn’t work. When I activate this measure the report turn empty. I believe there are some condition that generates this error.
Using the new condition:

Work%20Days%20in%20Rows
Work Days in Rows.PNG1326×515 29.2 KB

Full dashboard without new condition

burn%20down%20report
burn down report.PNG1035×376 22.5 KB

4

Hi,

I am sorry I didn’t explain how exactly this code should be used in your use-case.
Try this code for the calculated member in “Time” dimension

Aggregate(Filter(
 [Time].[Day].Members,
 DateDiffWorkDays( 
   [Time].CurrentHierarchyMember.StartDate, 
   [Time].CurrentHierarchyMember.NextStartDate 
   )=1
 )
)

This would aggregate all working days into a new calculated member which you could enable and expand in your report (finally remove header line) and only then switch from table view to chart.

Martins / eazyBI support