topic Re: Cumulative Sum Across Date Output Expression Not Working in App Development

Cumulative Sum Across Date Output Expression Not Working

azmeister3000 — Sat, 16 Nov 2024 00:24:37 GMT

Hi - I've got a chart where I've used the modifier to show the cumulative total by month of the set analysis. I need to do some further calculations on that number by month but the output expression doesn't work. Does anyone know how I can replicate what the chart/modifier is doing?

The end result I'm looking for is to be able to divide the 2nd column by the 3rd

Thanks

Re: Cumulative Sum Across Date Output Expression Not Working

GaryGiles — Fri, 19 Mar 2021 09:40:11 GMT

You can use the rangesum function to get similar results as using Modifier->Accumulation. Something like:

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) /

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

Re: Cumulative Sum Across Date Output Expression Not Working

azmeister3000 — Fri, 19 Mar 2021 09:33:28 GMT

hmmm getting a missing ( error

Re: Cumulative Sum Across Date Output Expression Not Working

GaryGiles — Fri, 19 Mar 2021 09:35:57 GMT

Sorry, I missed the closing '}' on the set analysis in the first expression. Try this:

rangesum(above(total Count(distinct {<[Interaction]={'Contact Created'}>} Email), 0, rowno(Total))) /

Count(distinct {<[Interaction]={'click'}>+<[Interaction]={'visited'}>} Email)

Re: Cumulative Sum Across Date Output Expression Not Working

azmeister3000 — Fri, 19 Mar 2021 09:38:14 GMT

Not sure why I was - working good!