Hi everyone, my requirement was to plot three different measures in only one line chart and to show/hide them with a checkbox. I really can't do this, can you help me?
Hello,
You can make a line chart with three 3 measures, but toggling the measures is not really possible as far as I know.
One workaround is to restructure your data .
From:
| A | B | C |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
To:
| Group | Value |
| A | 1 |
| A | 4 |
| B | 2 |
| B | 5 |
| C | 3 |
| C | 6 |
If you do that, then you can create a List control with the Group values and assign the Group variable to the Group role of the line chart.
Sam
Hello,
You can make a line chart with three 3 measures, but toggling the measures is not really possible as far as I know.
One workaround is to restructure your data .
From:
| A | B | C |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
To:
| Group | Value |
| A | 1 |
| A | 4 |
| B | 2 |
| B | 5 |
| C | 3 |
| C | 6 |
If you do that, then you can create a List control with the Group values and assign the Group variable to the Group role of the line chart.
Sam
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.