Multiple Measures?

Question

Multiple Measures?

Opened this issue 7 years ago · 4 comments

@turnerniles - any chance you have plans to support (or have talked with the quick-pivot team about) multiple measures? Aka, the ability to perform aggregation on more than one field?

Answer 1 · 2017-11-08T21:18:59.000Z

We had discussed it but weren't sure if it was worth the effort (if anyone would use it). @zheath Are you envisioning something like this?

Answer 2 · 2017-11-08T21:27:01.000Z

@pat310 - yes, this is exactly correct.

Answer 3 · 2017-11-10T03:33:16.000Z

@turnerniles @zheath It seems essentially, each additional aggregator/measure gets appended as another pivot to the right of the previous aggregator/measure pivot. And then we would also need to have multiple column totals.

Looking at a PivotTable.js issue as a reference, other contributors, have implemented multiple measure support but it was never implemented in PivotTable.js because PivotTable.js wasn't designed to support multiple measures/aggregators.

It adds some complexity to the quick-pivot and from a react-virtualized-pivot perspective we will have to add the ability to add multiple aggregators.

Answer 4 · 2017-11-10T04:02:50.000Z

I'll open an issue for it in quick-pivot. I think it can be done backwards compatible so will be a "minor" version increase (an array can be provided in the aggregations parameter). I think we should slate it for after the column totals feature.

…

On Nov 9, 2017, at 19:33, Niles Turner ***@***.***> wrote: @turnerniles @zheath It seems essentially, each additional aggregator/measure gets appended as another pivot to the right of the previous aggregator/measure pivot. And then we would also need to have multiple column totals. Looking at a PivotTable.js issue as a reference, other contributors, have implemented multiple measure support but it was never implemented in PivotTable.js because PivotTable.js wasn't designed to support multiple measures/aggregators. It adds some complexity to the quick-pivot and from a react-virtualized-pivot perspective we will have to add the ability to add multiple aggregators. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.