topic Re: Partially color the backround of a chart in SAS Visual Analytics

Partially color the backround of a chart

MWAG — Wed, 11 Oct 2023 11:16:24 GMT

I would like to color the backround in the line chart of the last three years.

Any idea how this could be done?

Re: Partially color the backround of a chart

Joy_SAS — Wed, 18 Oct 2023 21:09:25 GMT

I checked with the development team. Unfortunately, there isn't a way to do this with display rules in the current or previous releases of SAS Visual Analytics.

-Joy

Re: Partially color the backround of a chart

ballardw — Thu, 19 Oct 2023 14:40:08 GMT

I don't use Viya or Visual Analytics so this is guess of something that might be possible. If you can create a Polygon, either as a plot or annotate data you could provide a definition that corresponds to coordinates in you graph for that area. This would require you to set specific coordinates for each corner of the area manually so "last 3 years" is going to require you to calculate the first year, the last year to provide those values a x coordinate and the corresponding y value (zeros are usually easy ).

Overlay the series graph(s) over the polygon.

Maybe as I said.

Re: Partially color the backround of a chart

BrunoMueller — Mon, 23 Oct 2023 21:17:56 GMT

You can achieve this using the custom graph builder. The end result will look like this

Basic steps for creating the custom graph

create a new custom graph
add a band plot to the graph
assign the right y axis to the band plot
uncheck all the right y axis elements (line, label, values, tick marks)
do no display any grid lines for this axis
add either a timeseries or a series plot
both plots will share the x axis
save the custom graph

In your report, go to the objects pane and use the 3 vertical dots icon to import the new custom graph and add the custom graph to your report.

Create two calculated data items for the band plot part of the custom graph, based on what timeframe should be colored assign 0 to the band plot lower limit and a 1 to the band plot upper limit. For these two calculated items assign an aggregation of either min or max.

A sample expression for the lower limit might look like this:

if someDateYear >= todayYear -1
return 0
else .

someDateYear is the year of the date used for the x axis and todayYear is the year of "today", both are calculated data items.

Give it a try.

Re: Partially color the backround of a chart

MWAG — Tue, 24 Oct 2023 05:44:59 GMT

Thank you very much. That seems like a working solution. Unfortunately I do not have the rights for the graph builder. But in theory and as I can se within your example the solution works.

Re: Partially color the backround of a chart

yabwon — Tue, 24 Oct 2023 06:53:59 GMT

Hi,

you already have an answer but here is a "polygon" approach:

data have;
  do x = 1 to 10;
    Y = 0.5 * X + 1 + RANNOR(123);
    output;
  end;
run;

data polydata; /* create polygon data */
   input IDp :$ Xp Yp;
datalines;
1 6 0
1 10 0
1 10 10
1 6 10
;
run;

data toPlot; /* combine plot data and polygon data*/
  set have polydata;
run;


PROC SGPLOT data = toPlot;
  polygon X=xp Y=yp id=idp / 
    fill 
    nooutline 
    fillattrs=(color=green transparency=0.6) /* set polygon's transparency and colour */
  ;
  series x=x y=y;
run;

Result:

Bart