We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

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 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