Try to achive running count of ids for current month to last year same month

[pranaligawde]

Hello All,

Try to achive running count of ids for current month to last year same month.but without restriction.Asi want to showfor current year month till previous year same month.But it should conider all the values before current month .bit it is considering from selected month only.

Dimension :MonthYear

Measure:

RangeSum(Above( total count({<period={">=$(prevyeardate)<=$(curryeardate)"}>} distinct Management_Escalations_Open_Cases_for_balance_CI)

,0,RowNo()))

[pranaligawde]

Is there any clue on this??

kind help will  appreciate.

[tresesco]

If you are using latest (Feb 2020 or later) version of qs, you could use chart's 'Accumulation' feature under 'Modifier' settings.

 

[pranaligawde]

Yes,i could use but i also need to restrict month .and it should accumulated from last year current month -11 months till today.

[tresesco]

You can set that step too.

Range ->Custom, Step ->11

[pranaligawde]

Yes ,i did that but it's  not showing any change.

[pranaligawde]

Kindly check this attached

[tresesco]

Could you share your sample app?

[pranaligawde]

hello @tresesco ,

As requested,attached is the sample data qvf.

[tresesco]

I can see that values are accumulating without any selection. Can you explain your exact requirement (perhaps w.r.t. selection behavior) ?