topic Re: Highlight/Indent Row Item in a CrossTab Report in SAS Visual Analytics

Highlight/Indent Row Item in a CrossTab Report

Suvi2020 — Mon, 20 Apr 2020 18:08:11 GMT

Hello Members,

I am new to VA. I am trying to highlight a row of the crosstab either through some color or through indentation. I searched around the forum and found the below solution. But I don't think this functionality is available in the current version.

https://communities.sas.com/t5/SAS-Visual-Analytics/Display-rules-in-Crosstabs/m-p/263004#M3888

Thanks,

Suvi

Row/Cat	Cat1	Cat2	Cat3	Cat4
Row1	1	2	3	4
Row2	2	3	4	5
Row3	2	3	4	5
Row4	2	3	4	5
Total	7	11	15	19

Re: Highlight/Indent Row Item in a CrossTab Report

Joy_SAS — Mon, 20 Apr 2020 14:29:38 GMT

Hi @Suvi2020,

Unfortunately, there's not a feature that enables you to indent values in cells in a crosstab.

I'm not sure which version of SAS Visual Analytics you're using when you say "current" because there are multiple releases being used by customers right now. However, display rules (which you cross referenced in the other post from 2016) are available in the 8.x releases (in SAS Viya) and the 7.x releases (on SAS 9.4). You can create them using the Display Rules pane (on the right side by default).

The Display Rule documentation is available here: https://documentation.sas.com/?cdcId=vacdc&cdcVersion=8.5&docsetId=vareportdata&docsetTarget=p0i3hwaan0ivydn1cc0lzqgyqu0z.htm. (This is the 8.5 documentation. You can find all releases of SAS Visual Analytics documentation here: https://support.sas.com/en/software/visual-analytics-support.html#documentation.)

I hope this helps,

Joy

Re: Highlight/Indent Row Item in a CrossTab Report

Suvi2020 — Mon, 20 Apr 2020 16:42:45 GMT

Thanks @Joy_SAS !

After going through the documentation it looks like we can only do the display rule by creating condition on "Measure". is it possible to have a rule based on the category? Like I want to highlight it if the row value is "row3" as shown in the sample table in my original post.

Regards,

Suvi

Re: Highlight/Indent Row Item in a CrossTab Report

Sam_SAS — Mon, 20 Apr 2020 17:09:50 GMT

Hi Suvi,

The thread that you linked to in your first post will work in the current versions of VA.

Here, I have created a rule to highlight rows where Eye Color=Blue.

As you can see, there are some limitations to this approach. You must include the "Flag" calculated item in the crosstab. Only the cell for one measure in each row will be highlighted. But it might be better than nothing.

To achieve the result above, I created a calculated item named "Flag" with this expression:

IF ( 'Eye Color'n In ('Blue') )
RETURN 1
ELSE 0

I assigned Flag to the crosstab, then created a display rule based on Flag:

The Placement option specifies which column receives the highlight.

Let us know if that helps.

Thanks,

Sam

Re: Highlight/Indent Row Item in a CrossTab Report

Suvi2020 — Fri, 24 Apr 2020 14:34:27 GMT

Thanks, @Sam_SAS!

I used your suggested method and it works exactly as you have mentioned in your post. The only problem is it's not implementable in the report that I am trying to create as I have lots of columns and an additional column for each original column is not viable in the report.

I am not sure why it's not given as a feature in SAS VA as I think it's should be a standard feature(maybe with some restrictions) similar to the feature that is available for the listing report.

Thanks again for your solution!

Regards,

Suvi

Re: Highlight/Indent Row Item in a CrossTab Report

Sam_SAS — Fri, 24 Apr 2020 14:47:00 GMT

Yes, the workaround I offered is not actually that great 😞

I don't know why there is not an easy way to highlight a row with a display rule.

You should submit this request as an "idea" here:

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analytics

The development team reviews these, though it might take a while for them to look at it and respond.

Thanks,

Sam