How can we covert a metric into a dimension at the same time maintain the cross dimensional association between various dimensions.
For Example: I've to bucket payment into categories such as (0-1000,1000-2000.. etc.). At the same time be able to slice the data based on multiple dimensions.
One of the option that I had in mind was to use the aggr function: aggr(sum(payment),dimension1,dimension2,dimension3..etc) but this was failing as the data is too big and I'm getting a 'Calculation timed out' error
Another option was to get the sum(payment) in the back-end and group them by all the dimensions but this was resulting in a Synthetic key creation as I have a table with the similar dimensions which is being used to create Other views in the same app
