Hello all, could recommend a way to achieve the following?
I’d like to form row dimensions composed of range buckets of a given measure; let’s say in the dataset below, I want to find the total cost of all transactions of a certain quantity size, so transactions of quantity 5-9 are bucketed together, 10-14, etc. The following data
Would result in the (sum) aggregate result of
It seems that there would be a way to achieve this with calculated measures, but that results in additional measures. I figured your team would know a way to achieve it.
Thank you for your question.
In Flexmonster the desired output can be achieved by pre-processing the JSON data.
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/ny0v6e1j/.
Please let us know if this works fine for you.
You are welcome to contact us