Hi, I am new to eazyBI and run into a problem with DateDiffWorkdays. I need to tell how much time is between two date something like the code below but I get some weird number in the column “timeToDotoPublisher”. Can someone please show me the way to solve this problem? Thanks.
DateDiffDays(
NonEmptyString((
[Measures].[Transition to status first date],
[Transition Status].[To Do]
)),
NonEmptyString((
[Measures].[Transition to status last date],
[Transition Status].[Assigned to Publisher]
))
)
By the looks of the screenshot, it seems that you may have chosen the formatting “duration” → days/hours/minutes.
In order to use the duration formatting, you should always convert the days into minutes. To do that you must mutilply the measure by 24 (to convert days to hours) and 60 (to concert hours to minutes).
Try formula below along with the duration formatting and see if the report returns expected results for you
DateDiffDays(
NonEmptyString((
[Measures].[Transition to status first date],
[Transition Status].[To Do]
)),
NonEmptyString((
[Measures].[Transition to status last date],
[Transition Status].[Assigned to Publisher]
))
)
*24
*60
Hi @Elita.Kalane ,
thank you for the quick answer. It looks a bit more promising but something is still not right.
The rows are by Issue. Do you have more suggestion to investigate, please?
I would need to see the formula behind the measure WorkingDays in status until now.
It would be great if you could reach out to us directly (support@eazybi.com) referring to this Community Post and sharing your report definition (Export and import report definitions )
