[Lens] Ability to order columns in datatable

[dej611]

Describe the feature:

Lens datatable orders columns by default with bucket dimensions first, metrics then.
Columns can be currently ordered indirectly via the layer configuration panel, sorting the metric/bucketed dimensions.

Perhaps a better UX can be provided to the user, enabling columns rearrange on the table itself.
Also, that can be enabled in dashboard as well, as temporary rearrange (like the columns sorting).

[elasticmachine]

Pinging @elastic/kibana-visualizations @elastic/kibana-visualizations-external (Team:Visualizations)

[MarianaMartinYuste2]

Hi there,
Is there any update on this request that can be shared with customer?
Thank you

[stratoula]

I am pinging @ninoslavmiskovic here who is responsible for the team's roadmap.

[MarianaMartinYuste2]

Hi @stratoula @ninoslavmiskovic
If there are any news in this request, please share them here so that I can share with my customer.
Thanks!

[markov00]

We can probably use elastic/eui#8015
cc @MichaelMarcialis

[teresaalvarezsoler]

We want to allow users do this on the client-side without the need of editing the dashboard. Ideally there will be two scenarios:

• If the user makes the changes in "view" mode, the changes will only be visible and persistent for this user
• If the user makes the changes in "edit" mode and then save the dashboard, the changes will be saved with the visualization and hence visible to all users.

[MichaelMarcialis]

As @markov00 mentions above, EUI just recently added support for draggable column headers for the data grid component. This is something we can implement, as the Lens tables use the data grid component.

Additionally, if we plan to proceed with adding the "Columns" menu (mentioned in #193555), that also includes the ability to reorder columns via the menu as well.