Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
would you be able to share sample app to see what you have so far ?
I'm afraid I won't be able to do that since my app is on a virtual machine.
I'm afraid I won't be able to do that since my app is on a virtual machine.
you can maybe create a quick LOAD INLINE which represent your data structure ?