I have a Line graph which is to measure cumulative Issues with due date vs cumulative issues closed… however the graph shows count for future months also when it should not.
please advise any help.
Hi @Sujith,
Try using the Standard calculations introduced in eazyBI version 5.0 - https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure. There you can choose to define cumulative sum calculation that ignores empty values, introduced in version 6.0. That way, also ignoring future months where there are no issues with due dates in that period. See a picture below:
Best,
Roberts // support@eazybi.com
Hi Roberts,
Thanks for the suggestion, please find screenshot. my issues with due date exist even for future months, but cumulative issues closed count for future months should be empty which i am trying to achieve. I do notwant data for Cumulative closed issue count
Hi @Sujith,
It seems you are not using or don’t yet have access to the “without empty” feature in the “Cumulative sum” standard calculation. In that case, you can either filter the Time dimension to display members up until the current month or define new calculated measures that display the cumulative values if there are values for the original measure. See the formula below:
CASE WHEN [Measures].[Issues with due date] > 0
THEN
Sum(
{PreviousPeriods([Time].CurrentHierarchyMember),
[Time].CurrentHierarchyMember},
[Measures].[Issues with due date]
)
END
Please look at the eazyBI documentation page for more information on defining calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.
Best,
Roberts // support@eazybi.com