Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Column Cumulative Sum Function

Avatar

Level 6

8/25/17

We recently attempted to use the Cumulative Sum function in Adobe and discovered it basically doesn't work.

the idea would be update the Cumulative Sum function to dynamically adjust to the report that end user is reporting.

so if the dimension in the table are based on Day, then the cumulative function would just sum what is in the table.  Similarly to how the Column Sum function works.

the order should should adjust for however the table is sorted - so if we sort by day, then the Column Cumulative Sum would sort by day.  If the table was sorted by visitors then the Column Cumulative Sum would sort by Visitors

this should also work across

Day

eVars

sProps

Segments

as long as all of the appropriate details are available in the table I'm working in Workspace.

2 Comments

Avatar

Level 2

9/15/17

I'm constantly exporting data out of Analaytics to show a daily running cumulative total. To be able to do this in analytics would be much more beneficial.

Avatar

Community Advisor

10/13/21

+1 to this idea.

I'd simplify the idea like this:

The Cumulative function should work by the row numbers in the Freeform Table, not by (hashed) dimension values.