Acumulate values in Sense

[stekol61]

Hi!

I'm tying to crate a bar chart that show the accumulated open tickets (Inc_ID)  for a range of weeks.

When I use this expression the result is a value for each week , not the accumulated values.

'rangesum(above(count(distinct {<inc_status={'Open'}>} inc_ID),0 ))'

/Stefan

[sunny_talwar]

Try this

RangeSum(Above(Count(DISTINCT {<inc_status = {'Open'}>} inc_ID), 0, RowNo()))

[Anil_Babu_Samineni · Accepted solution]

Try this?

rangesum(above(count(distinct {<inc_status={'Open'}>} inc_ID),0, Rowno(TOTAL) ))