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

fsakjlfdsakljfd 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




Analysis Workspace Analytics
3 Comments (3 New)
3 Comments
amardeeps255847 04-02-2020

This would be amazing! The question is when? 🙂

nikitab02 04-02-2020

This would be great to have! 

jimmylama88 04-02-2020

big thumbs up for cumulative functions! ETAs? 😄