Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Column Cumulative Sum Function

Avatar

Avatar
Give Back 5
Level 5
jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Give Back 5
Level 5
jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
jeremyl59043873
Level 5

25-08-2017

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

Avatar
Give Back
Level 2
petero52240340
Level 2

Likes

2 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 1
Boost 1
View profile

Avatar
Give Back
Level 2
petero52240340
Level 2

Likes

2 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 3
Ignite 1
Validate 1
Boost 1
View profile
petero52240340
Level 2

15-09-2017

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

Avatar
Engage 10
Community Advisor
yuhuisg
Community Advisor

Likes

269 likes

Total Posts

709 posts

Correct reply

138 solutions
Top badges earned
Engage 10
Shape 10
Contributor 2
Ignite 10
Applaud 25
View profile

Avatar
Engage 10
Community Advisor
yuhuisg
Community Advisor

Likes

269 likes

Total Posts

709 posts

Correct reply

138 solutions
Top badges earned
Engage 10
Shape 10
Contributor 2
Ignite 10
Applaud 25
View profile
yuhuisg
Community Advisor

13-10-2021

+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.