Missing Bar in accoumulation

[agni_gold]

Hi guys ,

I am using rangesum function to show cumulative bars but between the chart bar is missing,

can you please help me on this

thanks

[sunny_talwar]

Would you be able to share you qvw?

[agni_gold]

Hi sunny ,

the qvw file on client location , i can't but ,

if possible can you tell me the reasons why this is happening , i will try to make correct .

[sunny_talwar]

Not entirely sure, but may be because the value is missing for that particular period.

[agni_gold]

for both bars ?

[sunny_talwar]

It seems blue one might have ended on 15 and not really sure about the grey bar

[agni_gold]

yes blue will end on 15 but for grey in need cumulative

[sunny_talwar]

What are your expressions?

[agni_gold]

for Greay Bar

RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[Target Budget])/1000000,0,

                Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date))"}> }Day)) )

for Blue bar

=RangeSum(above(Sum({<[Segment Entity]-= {""},Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }[ERP Amount USD])/1000000,0,

                 Sum({<Date= {">=$(=Min([Month Start Date]))<=$(v_Date)"}> }Day)) )

[agni_gold]

Got the error thanks sunny