What is the problem or goal the end user is trying to solve or accomplish?
Currently advance analytics is only available for time columns used on the x-axis, users would like to have this functionality expanded for numeric dimensions used on the x-axis as well.
How are they solving it currently?
Not possible
What is the recommended solution by the Customer?
Have advance analytics applied to numeric dimension in x-axis as well.
As far as I understood, numeric dimensions are sortable and should follow sae behaviour as time dimensions.
Is there any workaround for this? I mean, is there any way that I can compute a cummulative sum that actually respects dimensions in the query? Using any jinja macro or similar?
The problem is that I can use window function
sum() over (partition by ...)but I need to specify the columns to partition by dinamically.