Vue3 Pivot Table Multi Aggregate Upgrade component
Budget: €750 – €1,500 EUR
I built a custom Pivot table component in JS / Vue 3 for Frappe Framework, but it currently supports only one aggregate at a time. I want to extend it so the same table can show multiple aggregates side by side—e.g., Sum(A) and Sum(B) plus Average(C) and Count(D)—each rendered in its own cell, not merged or stacked.
Key goals
• Refactor the aggregation engine to accept an array of operations (Sum, Average, Count).
• Render every selected aggregate in a distinct cell that aligns with the existing row- and column-level breakouts.
• Keep the data source unchanged: the component still receives a JSON payload generated by a SQL query; no backend work is required.
• Preserve the current public API and styling conventions used across Frappe pages so that dropping the upgraded component into existing screens requires no markup changes.
• Optimise for large datasets (10k+ rows) and add simple unit tests to guard against regression.
What I will provide
– Current component codebase (Github access).
– URL to acces to full functional example with the current component
– UI guidelines so the new cells match the app’s look-and-feel.
Deliverables
1. Updated Vue component with multi-aggregate logic.
2. Any new composables, helpers
3. Documentation in README
4. Component will be installed with one of our dev team
skills :
If you’ve previously worked with Frappe Framework, let me know—that experience will be strategic. I’m aiming for a clean, maintainable solution that can be merged within 3 weeks.
Notes :
- to help developper, somes examples exists on the web : http://pranjalgoswami.in/multifact-pivottable/examples/
- we need visual interface to select fields for the multi agregation (more than one)
each field one calculation as Sum(A), Average (B), we do not need inter-field calculation as Sum(A/B)
Key goals
• Refactor the aggregation engine to accept an array of operations (Sum, Average, Count).
• Render every selected aggregate in a distinct cell that aligns with the existing row- and column-level breakouts.
• Keep the data source unchanged: the component still receives a JSON payload generated by a SQL query; no backend work is required.
• Preserve the current public API and styling conventions used across Frappe pages so that dropping the upgraded component into existing screens requires no markup changes.
• Optimise for large datasets (10k+ rows) and add simple unit tests to guard against regression.
What I will provide
– Current component codebase (Github access).
– URL to acces to full functional example with the current component
– UI guidelines so the new cells match the app’s look-and-feel.
Deliverables
1. Updated Vue component with multi-aggregate logic.
2. Any new composables, helpers
3. Documentation in README
4. Component will be installed with one of our dev team
skills :
If you’ve previously worked with Frappe Framework, let me know—that experience will be strategic. I’m aiming for a clean, maintainable solution that can be merged within 3 weeks.
Notes :
- to help developper, somes examples exists on the web : http://pranjalgoswami.in/multifact-pivottable/examples/
- we need visual interface to select fields for the multi agregation (more than one)
each field one calculation as Sum(A), Average (B), we do not need inter-field calculation as Sum(A/B)