we are having a bar chart with a single KPI but stacked by multiple selections. we want to set a default stack when no stacking option is selected when the dashboard is accessed. Is there any way to do so?
Snippets attached for reference.
Page 1 / 1
You can use an if-else statement to achieve this. A good option would be to assign a default value to the variable. When the variable is equal to the default value, use the default stackby, otherwise use the variable itself.
The syntax would look like this:
${a == 'Bob Broo' ? 'Table.Column' : a}
Here, "a" is the variable and the default value is "Bob Broo".
PS: don't keep any space while using the if else statement may throw an error
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.