Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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)
hmmm getting a missing ( error
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)
Not sure why I was - working good!