I want to add some insights on my dashboard and want to use the text container to write in my insights. at the same time, i also want to use a button bar labeled as insight 1, insight 2 etc to toggle between different insights/ text on the text container. is there a way to do this?
If you need help with the text object, please be more specific about what you want to do. A screen capture is very helpful for us if you can provide one.
You cannot select different data items by using a button bar, but what you can do is assign a parameter to the button bar and use a calculated item that displays different values depending on the value of the parameter. That expression might look something like this:
If ('MyParameter'p = 'Insight 1')
return 'Insight 1'n
else 'Insight 2'n
You can use this data item in your report objects and it will show different values based on the parameter value.
Note that you can cannot assign arbitrary text as the labels for a button bar. The labels are always the values of a category data item. The workaround is to create a calculated item or a custom category that will produce the desired values.
So that might look something like this:
If ('category'n StartsWith('A'))
return "Insight 1"
else "Insight 2"
You assign this calculated item to the Category role of the button bar. The actual condition you use can be anything so long as your data will produce both results.
When you use this trick, it is important that the button bar does NOT perform a filter action (unless this is desired, I suppose). Be sure that the button bar is not placed in the report prompt area or the page prompt area, and check the Actions pane to be sure that no filter actions are defined for the button bar.
Let us know if that helps,
Maybe you could use a text object for choosing the insights instead of a button bar, and put each insight on its own hidden page. Then in the first text box, link the text to the hidden pages. Like this
In view mode, it would look like this:
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.