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

Return values Using the 'Cumulative Function' based on the order of the rows in the table.

Avatar

Avatar
Boost 50
Level 5
fsakjlfdsakljfd
Level 5

Likes

50 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Boost 50
Give Back 50
Give Back 25
Give Back 10
Shape 1
View profile

Avatar
Boost 50
Level 5
fsakjlfdsakljfd
Level 5

Likes

50 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Boost 50
Give Back 50
Give Back 25
Give Back 10
Shape 1
View profile
fsakjlfdsakljfd
Level 5

31-01-2020

Currently when using the cumulative function, the data is evaluated and returned based on the 'as ordered by the dimension, using hash values for string based fields'.

This returns intuitive results for continuous variables, like dates, and for many ordinal variables, like Time Spent  per Visit (Bucketed).

But it also creates scenarios in which unexpected results might occur or the function is less usable.

As an example if a client uses a week range of Monday-Sunday, the data is presented as expected when ordering by dimension, but when using the cumulative function the values are aggregated in a different order as Sunday has a lower hashed-id than Monday.
DayOfWeekExamplev2.png

Additionally for non-ordinal values the function doesn't really have utility - but could!
PricePerProductExample.png
This request would be to instead accumulate the data based on the order of the rows within the table.  This would especially be valuable now that table builder provides the ability to display non-ordinal or continuous values based on user selection, rather than metric ordering.

As an example, a classified eVar, in which it would be most beneficial to display data related to categories that have order, but cannot be defined as such within Adobe's back-end.

Price Per Product V2.png




3 Comments

Avatar

Avatar
Ignite 1
Level 1
amardeeps255847
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

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

Avatar
Ignite 1
Level 1
amardeeps255847
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Ignite 1
Give Back
Validate 1
View profile
amardeeps255847
Level 1

04-02-2020

This would be amazing! The question is when? 🙂

Avatar

Avatar
Level 1
nikitab02
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
nikitab02
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
nikitab02
Level 1

04-02-2020

This would be great to have! 

Avatar

Avatar
Level 1
jimmylama88
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
jimmylama88
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
jimmylama88
Level 1

04-02-2020

big thumbs up for cumulative functions! ETAs? 😄