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
[
{
Quantity: 10
Cost: 1.00
},
{
Quantity: 20
Cost: 1.20
},
{
Quantity: 5
Cost: 1.00
},
{
Quantity: 12
Cost: 2.00
},
{
Quantity: 7
Cost: 1.00
}
]
Would result in the (sum) aggregate result of
5-9: 2.00
10-14: 3.00
15-19: 0.00
20-24: 1.20
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.
Hello, Daniel,
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
Best Regards,
Vera