@Elita.Kalane
Hey, I have created a user defined value for overdue issues something like this:
CASE WHEN
[Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember
THEN
– when no time dimension is used in the report get today
SUM(
PreviousPeriods(
[Time].CurrentHierarchy.Levels(“Day”).CurrentDateMember),
[Measures].[Issues due]
–example reusable for any date custom field use instead of measure Issued due
– ([Measures].[Issues with due date],
– [Resolution].[(unresolved)])
)
WHEN
– with time dimension in the report apply the calcualtion for past dates and today only
DateAfterPeriodEnd(“Today”, [Time].CurrentHierarchyMember)
OR
DateInPeriod(“Today”, [Time].CurrentHierarchyMember)
THEN
SUM(
PreviousPeriods(
[Time].CurrentHierarchyMember),
[Measures].[Issues due]
–example reusable for any date custom field use instead of measure Issued due
– ([Measures].[Issues with due date],
– [Resolution].[(unresolved)])
)
END
But the problem here is when I select the “all time” option in time, it displays the value but when I change it to quarter or anything else the values disappear even though the due date is there but it does not appear.
P.S: I have added time field in pages section.
Hi @ayushlawania,
The formula comes from the eazyBI Demo account - Issues due and overdue - Issues - Jira Demo - eazyBI. It returns currently open overdue issues. The numbers are tied to the Time dimension to the period issues are due. I suspect that no currently open issues are due in the selected Time dimension period, which is why the measure is empty for a particular quarter.
If you look for historical information - how many overdue issues were in a past period, I recommend the “Overdue issues in period” measure from the above report.
Please provide more details if I misunderstood your problem.
Best,
Roberts // support@eazybi.com
I do have issues overdue in the time period which I am selecting, but still shows nothing and this is the exact formula I want, but it shows issues if I select “all times” but if I select particular quarter it does not show any issues, even though those issues are overdue at that selected time frame.
Hi @ayushlawania,
Please export and share the definition of the report to the eazyBI support email support@eazybi.com and reference this community post - Export and import report definitions.
Please also include a screenshot of the report and a screenshot of an issue that is currently overdue.
Best,
Roberts // support@eazybi.com
Done, I have sent an email to the above mentioned email id, kindly check and let me know the possible solution.