BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rjassem1
Obsidian | Level 7

I can't seem to add a single number in a report in SAS VA/Viya 8.1. Then I tried using a gauge but it doesn't seem to work with percentages and the filter doesn't apply since the min and max values are fixed.  Any idea how I can add a percentage as a single value in a report?

1 ACCEPTED SOLUTION

Accepted Solutions
rjassem1
Obsidian | Level 7

I'm using a text object and there aren't really any options there. I noticed that there are a lot of features that are no longer available in 8.1. 

 

I did a workaround. I wanted to display a percentage so I had to create a custom category variable with the sub-categories I wanted to count then created a measure for the percent of the sub-categories in relation to all the categories. I added that measure to the gauge and adjusted the rules with a max of 100 or actually 1. 

 

It seems like a lot to get a simple percentage! That being said, I wish it could have just been in a text box. 

 

 

View solution in original post

7 REPLIES 7
rjassem1
Obsidian | Level 7

I ended up creating a percentage and adding it to the gauge and creating another measure with a value of 100 and adding it to the gauge. I wish I could just add a number in a text box.

Madelyn_SAS
SAS Super FREQ

You can do this in 8.2 using a new object called Key Value.

 

In 8.1, you can use a text object and assign a measure to the role.

rjassem1
Obsidian | Level 7

We have 8.1. I tried adding a measure to a role for a text box but it says "roles cannot be applied to the selected object" 

Madelyn_SAS
SAS Super FREQ

Are you using a Text object or a Text Input control? If you are using a Text object, it is possible that 8.1 did not have the ability to add a measure to the role like you can in 7.4 and 8.2.

 

If the Text object isn't available to you, it should be possible to adapt this sample (written for 7.3) and use a gauge.

 

http://support.sas.com/kb/58/288.html

 

At the moment, the images are misplaced, but if you wait a little while, the note should refresh to show the images correctly.

 

 

rjassem1
Obsidian | Level 7

I'm using a text object and there aren't really any options there. I noticed that there are a lot of features that are no longer available in 8.1. 

 

I did a workaround. I wanted to display a percentage so I had to create a custom category variable with the sub-categories I wanted to count then created a measure for the percent of the sub-categories in relation to all the categories. I added that measure to the gauge and adjusted the rules with a max of 100 or actually 1. 

 

It seems like a lot to get a simple percentage! That being said, I wish it could have just been in a text box. 

 

 

don_data
Fluorite | Level 6

While not optimum, there is a crude workaround in 8.1. It takes a lot more effort. 

 

Approach 1: Use a measure in a list table. Use the format options to blend the cell background and remove titles. This works best on a white background.

 

Approach 2: Use a  category with a treemap. Remove the skin from the treemap in options and use display rules to blend into the background.  

 

 

This is a lot easier in 8.2 using the key value object. 8.2 also allows parameters to be passed through to text objects allowing for dynamic text.

 

rjassem1
Obsidian | Level 7

Thank you. Approach 2 seems to cause some problems. Approach 1 works except that I can't change the background for unpopulated columns but I can make it smaller so that the grey doesn't show that much and the scroll bars don't show.  
Screenshot 2018-04-06 12.56.35.pngScreenshot 2018-04-06 13.01.34.png

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 7 replies
  • 1631 views
  • 2 likes
  • 3 in conversation