Range

[smilingjohn]

Hi All, 

I am showing a line chart with the help of  range sum expression . ( The graph is showing the cummulative but not any dip ) 

rangeSum(above(TOTAL count({<Category={'Medium'},STATUS={'Open'}>}ID),0,RowNo(TOTAL)))
-
count({<Category={'Medium'},STATUS={'Closed'}>}ID)

And also how do I include the load date in the expression as some of the the defects closes on load date ? 

How should I change the expression to get this resolved 

Thanks in advance 

[smilingjohn]

And I also how do i include the load date in the the expression sp that range sum trend can take the effect of the changes or the ticket close on a perticular laod date . 

rangeSum(above(TOTAL count({<Category={'Medium'},STATUS={'Open'}>}ID),0,RowNo(TOTAL))) 

????/ How to include the load date in the above expression 

Thanks in Advance 

[#3]

rangeSum(above(TOTAL count({<Category={'Medium'},STATUS={'Open'}>}ID),0,RowNo(TOTAL))) 

????/ How to include the load date in the above expression 

Thanks in Advance 

[Brett_Bleess]

You will likely need to attach the QVW or a sample file in order for folks to provide the solution in this case.

Regards,
Brett