Hi EazyBI community, I would like to calculate the difference between to dates (Issues created at and Issues Date of first response).
My calculation looks like this:
[Issue].CurrentHierarchyMember.get('Issues created at'),
[Issue].CurrentHierarchyMember.get('Issues [CHART] Date or first Response'),
Unfortunately within my table I do not receive any value back.
I have checked the format which is set to yyyy-mm-dd hh:mi:ss Date and time as the other measures use this format.
Could someone please support me here.
DeteDiffWorkdays() is the right function to calculate the duration between two dates. The outcome is the duration expressed as a number of days, not a date. You might want to set measure formatting to ###.## decimal.
The calcaution is based on issue properties and compares dates for individual issues; therefore, it would work only when individual issues are on report rows. This sample report might help you to understand the concept better why some calculation work only for specific layout: Project issues with details.
Zane / support@eazyBI.com