Looking for a way to display dynamic text in a text box in SAS Visual Analytics? Look no further. You can allow a button bar control object to masquerade as a text box. Let me tell you how.
The report below includes a title that displays text along with the value of the selected period.
The report example includes a list table object that displays data for periods. A period (Date by Month) is selected using a drop-down list. A button bar is incorporated to display the header text, the category role for the button specified as the value of a calculated data item, Report Description.
This example uses a calculated data item (Report Description) created in the designer. The expression for calculated data item Report Description makes use of the concatenation and format operators to combine text and numeric information. The expression in both visual and text mode:
Filter Interactions are defined between the drop-down list and the list table and the drop-down list and the button bar.
Now how about adding a second title line (another button bar) that contains the total operations expenses value for that month?
For this example, it would be great if we could create an aggregation (sum overall) and concatenate that value, but we’re unable to use an aggregation in a calculation. So instead, just use the Visual Data builder to create a new table containing only the aggregations of operational expenses by the Date by Month data item. Once you have your new table (sample below) you can then create a new button bar based on the new table.
The Category role for the new button bar will be the value of a new calculated data item, total operational expenses. The visual and text versions of the expression are below:
One additional interaction is added, as shown:
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.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.