[DataGridPremium] Pivoting PoC

[cherniavskii]

WIP

https://deploy-preview-9877--material-ui-x.netlify.app/x/react-data-grid/pivoting/

Related to #214

[mui-bot]

Deploy preview: https://deploy-preview-9877--material-ui-x.netlify.app/

Updated pages:

• docs/data/data-grid/aggregation/aggregation.md
• docs/data/data-grid/pivoting/pivoting.md

Generated by :no_entry_sign: dangerJS against 1ac1eed1a8e03fe6aa1061a10e30165ef50dcd53

[gerdadesign]

TY for all your work on this so far! Adding some design explorations to enhance the initial PoC. @joserodolfofreitas would love your feedback here as well.

Loom walkthrough Figma Sketches 1

---

Summary

• Proposed 2 explorations as the entry point into the Pivoting feature.
• Both required a reexamination of the Toolbar and the V2 of the Columns panel.
• Exploration 1 was to add a Pivoting option as a separate panel to the Toolbar.
• Exploration 2 (what Olivier suggested) was to add Pivoting as something you can enable in the Columns panel.

[gerdadesign]

Thanks for both of your feedback so far, @cherniavskii and @joserodolfofreitas !

I incorporated the feedback into the second round that addressed:

1. how the interaction opens (menu dialog vs side panel).
2. corrected for the visual indicator differences between the column management panel and the pivoting mode (which wiped clean things like grouping that would have been reflected in non-pivot mode)
3. It seems there were also some confusion about the intended interaction of opening a submenu to access sorting, filtering, etc. I tried to make that clearer moving forward.

Take a look at the sketches walkthrough! I added a lot of notes, but happy to add in a loom video walkthrough as well if you find that helpful.

Figma sketches 2

[gerdadesign]

Thank you again for the feedback session! I've done a short exploration based on our discussion that should hopefully move the needle forward a little bit. @noraleonte can take over any additional questions!

Figma sketches 3 Summary

• Listed out the decisions so far:
  • toolbar changes
  • the long term plan for the side panel and the interim plan for a popup menu for Manage Columns + Filtering
  • linked to the Manage Columns interactions from the previous iteration since we seemed fairly settled on that one
• Pivoting Panel interaction options
  • Pushing the dropdown selection vs drag vs balanced
• Field options
  • After our discussion, simplifying this so it's not a mirror of Manage Columns submenu
  • Exploring how to show the adjustments you can make to each field (sorting/ordering and aggregation)

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[kumargauravin]

Any update on this one we have a usecase to show table with adding data on scroll with ability to pivot table on a date and different Line of Bussinesses

[timmyg]

❤️

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[cherniavskii]

Tagging @mui/xgrid for an early review

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.

[github-actions[bot]]

This pull request has conflicts, please resolve those before we can evaluate the pull request.