topic Re: Acumulate values in Sense in App Development

Acumulate values in Sense

stekol61 — Thu, 13 Dec 2018 13:14:08 GMT

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 — Thu, 13 Dec 2018 13:16:46 GMT

Try this

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

Anil_Babu_Samineni — Thu, 13 Dec 2018 13:17:15 GMT

Try this?

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