Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using a variable input so the user can choose the chart he need to see.
The variable include selecting between 2 values - A and B.
Both values are include in the Group field (total of 3 values - A, B, C).
Now the customer ask to add a filter of Group.
I need to 'connect' between the filter and the variable input.
For examples:
When the user filter by Group=A, the variable get 'A' and the relevant chart is presented.
When the user filter by Group=C, he will receive a message that there is no relevant chart for the selection.
The client doesn't want to delete the variable input so he can move between charts without filtering.
My problem is when selection a group, I need to make another selection (in the variable input) to move the right chart. Without the extra move, I'm staying in the current chart even if there are no data.
Please give me some ideas to solve this issue.
There might be a couple of ways to achieve this.
1) Utilise the Container or Layout Container Object. You can create the charts you want and then show/hide using the variable input
2) Within the chart dimension or measure, do an 'IF' Statement the references the variable to change the chart to your linkings.