Cumulative Sum Across Date Output Expression Not Working

[azmeister3000]

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

[GaryGiles · Accepted solution]

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)

[azmeister3000]

hmmm getting a missing ( error

[GaryGiles · Accepted solution]

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)

[azmeister3000]

Not sure why I was - working good!