topic Accumulating count zero when selecting dates in App Development

Accumulating count zero when selecting dates

gal_polak — Sat, 16 Nov 2024 03:53:25 GMT

Hi,

I have a line chart that basically count the number of users i have on time line, with accumulating formula:

RangeSum(Above(Count({$<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation)>} Distinct UserID), 0, RowNo()))

but when selecting dates in the chart, the numbers are dropping,
i guess i understand way,

but how can i prevent this?

I would like to be able to filter the count with other dimensions but disregard the slicing of the time dimension in the line chart.

see attached video

Re: Accumulating count zero when selecting dates

sunny_talwar — Mon, 09 Dec 2019 12:58:16 GMT

Try ignoring selection in Date field within the Count() function and then multiply with a dummy expression

RangeSum(Above( Count({$<DateField, RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation)>} Distinct UserID) , 0, RowNo())) * Avg({<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation)>} 1)

Re: Accumulating count zero when selecting dates

gal_polak — Mon, 09 Dec 2019 13:17:29 GMT

So what you suggested didn't work.

but it seems that this is working:

$(= RangeSum(Above( Count({$<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation),Date={'<$(=Min(Date))'}, [Week Start Date]=>} Distinct UserID) ,0,RowNo())) ) + RangeSum(Above(Count({$<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation)>} Distinct UserID), 0, RowNo()))

basically adding the accumulating count up until the selected date.

Re: Accumulating count zero when selecting dates

sunny_talwar — Mon, 09 Dec 2019 13:21:02 GMT

If this is the route you want to go... why do you need RangeSum() in the first part of the expression... this should work too

$(=Count({$<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation),Date={'<$(=Min(Date))'}, [Week Start Date]=>} Distinct UserID) ) + RangeSum(Above(Count({$<RecordSource = {'UserCreated'}, $(=SetAnalysisPopulation)>} Distinct UserID), 0, RowNo()))

Having said that, the expression I provided should have worked as well... all you needed was to replace the field you are making selection/s in the first part of the expression.

Re: Accumulating count zero when selecting dates

gal_polak — Mon, 09 Dec 2019 13:29:41 GMT

I guess you are right,

also tested what you suggested, and it works the same.

thx!