Form dimension values from measure ranges

Answered
Daniel Rutledge asked on September 3, 2019

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.

1 answer

Public
Vera Didenko Flexmonster September 4, 2019

 
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

Please login or Register to Submit Answer