Toggle Between Primary Keys Using Variables

Asuod_ — Fri, 27 Sep 2024 20:11:51 GMT

Hello,

I have been tasked with creating a dashboard that allows users to toggle between two different unique IDs, using them as the primary key. By default, the dashboard loads with `ID_1`, but users should be able to switch to `ID_2` through a variable toggle.

My question is: how can I configure this variable and apply it in the visualizations? Should I use something like a `vPrimaryKey` variable as a measure, or is there a better approach to handle this requirement?

I would appreciate any guidance or alternative solutions. Thank you!

Re: Toggle Between Primary Keys Using Variables

rubenmarin — Sat, 28 Sep 2024 07:24:15 GMT

Hi, I'm not sure to follow but maybe you could use set analysis on the dashboard measures like:

Sum({<IDField={'$(vPrimaryKey)'}>} Value)

The bold part of set analysis should be in all the expression of the dasboard.

Or set a button with actions that: unlocks IDField, removes the selections on IDField, makes the new selections on IDField and locks it.

topic Re: Toggle Between Primary Keys Using Variables in App Development

Toggle Between Primary Keys Using Variables

Re: Toggle Between Primary Keys Using Variables