Accumulation not working as expected. Getting line chart for the future Order dates

dhasharadh — Wed, 19 Jan 2022 16:12:49 GMT

Hi All, requirement is to show the Order executions in accumulation for the current month which is Jan 2022. But am getting extra dates greater than today.

Dim : Round(Order_Date - Monthend(Order_Date),1)

Exp 1 : Jan 2022 :

Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today()),'YYYYMM')) } >} Source_Id)

Exp 2 : Dec 2021 :

Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-1),'YYYYMM')) } >} Source_Id)

Exp 3 : Jan 2021 :

Count({< Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-12),'YYYYMM')) } >} Source_Id)

Full accumulation, with step 6... if I Use full accumulation with no step then my 2022 Jan line is straight line till the end.

expectation is (last loaded date) 9 - 31(monthend) = -21, current month line chart should stop here it self. but it is going till -14. Please help

@sunny_talwar @Anil_Babu_Samineni @jagan @marcus_sommer @Jonathan_Dienst @Clever_Anjos

@Michael_Tarallo any other expert please provide the inputs.

attaching the sample data.

Findings : when we only keep Jan 2022 expression, then x axis is limited to -20 only. and when we add all the expressions

topic Accumulation not working as expected. Getting line chart for the future Order dates in App Development

Accumulation not working as expected. Getting line chart for the future Order dates