Allow end users to view and manipulate hidden context selectors temporarily while pivoting a grid

JoannaC

In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds:

Oftentimes, a page builder hides certain context selector because they serve no purpose, introduce unwanted cognitive burden (in the default design), or want to provide as streamlined a UX as possible…HOWEVER, when pivoting is enabled for grids on a dashboard/card, all users should be able to get the benefits of that pivot capability.

In the current state they don't.

Observed functionality is that the end user is able to pivot dimensions across context selectors, rows and columns…but if a grid dimension is moved to the context selector position and that same dimension is shared by another card with the default config being that same dimension in the context selector position and has been HIDDEN by the page builder, the context selector remains hidden for the newly pivoted grid…thus rendering the pivot mostly useless.

How often is this impacting your users?

Any time grids are pivoted where dimensions have been hidden in the default page design.

Who is this impacting? (ex. model builders, solution architects, partners, admins, integration experts, business/end users, executive-level business users)

All users, but page builders can resolve with page editing workarounds, though not ideal.

What would your ideal solution be? How would it add value to your current experience?

Executing a pivot should temporarily display all the available dimensions for an end user to manipulate in order to get the most out of the data investigation.

Please include any images to help illustrate your experience.