BookmarkSubscribeRSS Feed
vaibhavchavan
Calcite | Level 5

Hi,

 

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? 

@Sam_SAS 

3 REPLIES 3
Sam_SAS
SAS Employee

Hello,

 

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,

Sam

Madelyn_SAS
SAS Super FREQ

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 

Madelyn_SAS_0-1661199883478.png
In view mode, it would look like this: 

 

Madelyn_SAS_1-1661199941949.png

 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 678 views
  • 4 likes
  • 3 in conversation