Multiple Measures?

[zheath]

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

[pat310]

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?

[zheath]

@pat310 - yes, this is exactly correct.

[turnerniles]

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

[pat310]

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 [email protected] 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.