Multiple Aggregator

[SAMJN]

Hi nicolaskruchten, this issue is related to Multiple aggregator - displaying sum/ average/ mean.....
against to entries as we can do in MS-Excel. Now this issue has been reported in #30 and #73 . But still I wanted to ask if you plan to add multiple aggregator. i tried to change parameters in Sum Over Sum, as it takes different aggregators. But as currently aggregators return only single value and not an array, Multiple aggregator is not possible. Could you help me further

[nicolaskruchten]

Implementing multiple aggregators is a major UI challenge and I don't have the time at the moment to envision when it could be done. Basically, multiple aggregators are not on the roadmap for this project.

[SAMJN]

Could you guide me whether my thinking is right or not? I will have to make changes in PivotData functions, custom aggregator, custom renderer and some in PivotUI() and Pivot().
The changes done by others involves hard coded parameters(Vals, Cols, Rows), whereas I am passing dynamic parameters (when a user change the fields, chart should again render).

[nicolaskruchten]

Yes, you will have to change pretty much every part of the system to accommodate this feature :)

…

On Wed, Apr 12, 2017 at 08:19 Saumya Jain ***@***.***> wrote: Could you guide me whether my thinking is right or not? I will have to make changes in PivotData functions, custom aggregator, custom renderer and some in PivotUI() and Pivot(). The changes done by others involves hard coded parameters(Vals, Cols, Rows), whereas I am passing dynamic parameters (when a user change the fields, chart should again render). — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#684 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAMbAw8TDCmhSMgIc8j2um6sqzm3iSTcks5rvMFrgaJpZM4M7Q67> .

[SAMJN]

Thanks for the help. I will let you know if I touch a breakthrough.

[gzsombor]

@SAMJN : Have you been able to achieve success? I would like to have something similar ...

[SAMJN]

I tried changing function, but due to shortage of time, I didn't got any success. I am planning to work on it, and will post here as soon as I get any success.

[SAMJN]

Hi,

I have developed a solution to existing library for Multi-metric and support of Group total charts too. I will upload my solution by end of first week of December 17. Will create a new issue and mention link here too

[SAMJN]

Hi All,

PivotTableMultiMetric In the file pivot.js attached in this repository, you can refer for multiple metrics support of Pivot Table. Kindly start watching the repository, I will update the library with my work of heatmap and subtotals soon. Refer #846

[SuleymanS]

Nice job SAMJN. congratulations.

but I need my 3 total columns. Is this possible ?

[SAMJN]

Hi @SuleymanS , are you asking about creating separate total columns for separate metrics? I guess currently, I have provided one total column, displaying individual totals.

[pranjal-goswami]

Hi!
I have attempted to write a plugin for adding multiple aggregations on different fields and have published them here: https://github.com/pranjal-goswami/multifact-pivottable

Using this plugin you can :

• Add multiple aggregations to the same pivottable: AVG(Column A), SUM(Column B)

• Add derived aggregations :
  -- a = AVG(Column A)
  -- b = SUM(Column B)
  -- [c = b/a] as 'Success Score'

• Hide an aggregate (in case you want to use the value in derived aggregate but not show it)

• Hide an aggregate from row-totals section

• Enhance rendering of aggregations using heatmap or barchart

• Custom heatmap colors for each aggregation

A demo is available here: http://pranjalgoswami.in/multifact-pivottable/examples/

Will add detailed documentation if people find the plugin useful.

[abhikvnair]

Thank You............
It is absolutely wonderful plugin for PivotTable.js.
Please upload detailed documentation.

[abhikvnair]

While using locale error showing.Please update lib with example of locale

[prnshamahrjn]

Could there be multiple pvtTable within single initialization?

[BBBhatt]

just want to format numbers without decimal places..
what options should i Use with it?

-Thanks,
Bhavin.