In creating a SAS viya dashboard I want the following calculated column as a category with % symbol
'Graduated in 2 Years'n / 'Enrolled (Distinct Count)'n
Oh, I see. The problem is the nested operations when you have an aggregated measure (Distinct Count) in the expression. I think the best workaround is to pre-calculate the distinct count as part of your data preparation.
If you have the very latest version of VA (2024.05), you can work around this by calculating the distinct count as part of an expression-based parameter.
Hello,
You can apply a Percent format to the numeric value, if you just want to display the % symbol. (Change the data item properties in the Data pane.)
If you really need the value to be a category value, you can use the Format() operator.
For example,
Oh, I see. The problem is the nested operations when you have an aggregated measure (Distinct Count) in the expression. I think the best workaround is to pre-calculate the distinct count as part of your data preparation.
If you have the very latest version of VA (2024.05), you can work around this by calculating the distinct count as part of an expression-based parameter.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.