Pivot table plotting improvements

[spine-o-bot]

In GitLab by @soininen on Jan 12, 2021, 13:04

Some possible improvements for plotting in Database editor's pivot table from #1124 (Juha brought more on 22.9.2021)

• Make sure the initial choice for the plot as X column is sane in index expansion mode (should be the Index column) (confirmed)
  1. [ ] The X column could try to 'follow' its position when pivot table's shape changes
  2. [ ] Rename '(X)' to 'Plot as X'
  3. [ ] Call the other columns 'Plot as series'?
• Possibility to choose a 'Plot as Y' column? (open a new issue if we end up wanting to have more plotting tags for columns)
  4. [ ] It would be great if the plot would update when the user switches between alternatives (in the "Alternative/Scenario tree" tab or in the "Frozen table" tab).
  5. [ ] One should be able to choose multiple items from the Frozen table at once.
  6. [ ] When moving dimensions in the pivot view (e.g. from 'frozen table' to y-axis), the selection resets and nothing is selected anymore in the 'frozen table'. It would be nice to have something sensible selected there even after dimensions are moved around.

[spine-o-bot]

In GitLab by @jkiviluo on Jan 12, 2021, 22:29

Yes, the initial choice for X is indeed the index column. However, when you change the number of dimensions on the columns, the X columns stays on the original column. If you remove one dimension from columns, then you get a value column instead of index column.

[spine-o-bot]

In GitLab by @jkiviluo on Jan 12, 2021, 22:40

Maybe that 'Plot as Y' is too much right now. There are also other alternatives to manage this (maybe also y-axis, i.e. row, indexes should be able to get a tag like Plot as X) and we need to give it a careful evaluation. Just noting as a clarification that this kind of capability would get into the territory of e.g. bar plots.

[spine-o-bot]

In GitLab by @jkiviluo on Jan 12, 2021, 22:41

One could have two (or more) columns as 'plot as X' - that would create category plus subcategory. You can do it in Excel too and it can be quite useful.

[spine-o-bot]

In GitLab by @soininen on Jan 13, 2021, 07:37

changed the description