topic SAS VA Line Chart - Group and color by different categories in SAS Visual Analytics

SAS VA Line Chart - Group and color by different categories

dishen_pancholi — Wed, 06 Apr 2022 15:33:16 GMT

Hello Everyone,

I have a requirement wherein I need to use one field for grouping and a separate field to color the lines. How shall I achieve this in SAS VA. I also tried creating a custom line chart using the custom graph builder but I am unable to add a 'Color' role if I have a 'Group by' role.

Thanks,

Dishen

Re: SAS VA Line Chart - Group and color by different categories

Madelyn_SAS — Wed, 06 Apr 2022 16:10:06 GMT

Which version are you using? What about using display rules to specify the individual colors?

Re: SAS VA Line Chart - Group and color by different categories

dishen_pancholi — Thu, 07 Apr 2022 02:35:46 GMT

Hello Madelyn,

I am using Viya 8.4. And i tried using display rules but it didn't work. There was no change in the graph when I defined the display rules since the color based on the group by variable takes precedence over display rules.

Re: SAS VA Line Chart - Group and color by different categories

acordes — Thu, 07 Apr 2022 09:01:29 GMT

One strategy would consist in

creating a custom graph with the graph builder like a line chart with the group option but removing the automatic color option putting background color insted
use the object's display rules to make the line chart color respond to conditions like comparing two variables