Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

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