🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Form dimension values from measure ranges

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

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,

Please login or Register to Submit Answer