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

Hi,

Inspired by @TeriPatsilaras post on using parameters to highlight data points, I'm using Visual Analytics 8.3 to extend her ideas to line charts.  My goal is to get graph of multiple lines (set by the group category) to all be a gray or muted color, with the highlighted line (driven by a parameter as Teri outlines) a brighter color.  Analogous to the "Number of Super Bowl Wins" graph in her first figure in the link above.  Something like this: 

Annotation 2019-12-13 115104.png

Although I can replicate Teri's approach using bar charts, with line charts, I get this error: "The report object uses rules that might conflict with essential color mapping. Use the Rules pane to remove the conflicts." The rules in question are the analogue to Teri's SelectedTeamFlag display rule.

 

I tried another approach, creating a custom graph of two line charts overlaid, with the idea of one chart showing the muted non-selected "teams" and the other showing the selected "team" as a bright line.  But here I get the error message: "The line chart encountered duplicate line classification data values and cannot be displayed."  In this case, the chart with the highlighted team is not displaying.

 

Any suggestions for things to try?  Another way to approach?  Here is the effect I'm after:

 

Thanks so much, 

Andy

 

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

It is a while since the question came up, there is a way to do this.

 

The beginning will be the same:

create a dropdown to select the one to highlight and put the value into a parameter

then create a new calculated item as follows:

IF ( 'Continent Name'n = 'selectedContinent'p )
RETURN '_#_'
ELSE Concatenate('Continent Name'n, '_#_')

Use the new item as group element in your line chart, do not display any legend

Create a new display rule using the new calculated item: use your favorite color for the "_#_" value and some other for all the others

 

View solution in original post

2 REPLIES 2
BrunoMueller
SAS Super FREQ

It is a while since the question came up, there is a way to do this.

 

The beginning will be the same:

create a dropdown to select the one to highlight and put the value into a parameter

then create a new calculated item as follows:

IF ( 'Continent Name'n = 'selectedContinent'p )
RETURN '_#_'
ELSE Concatenate('Continent Name'n, '_#_')

Use the new item as group element in your line chart, do not display any legend

Create a new display rule using the new calculated item: use your favorite color for the "_#_" value and some other for all the others

 

abaxter
Fluorite | Level 6

@BrunoMueller , thank you so much for this creative solution.  It worked perfectly!  I really appreciate it.

Andy

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 2 replies
  • 2028 views
  • 0 likes
  • 2 in conversation