topic Re: Dynamic Value on Reference Line in SAS Visual Analytics

Dynamic Value on Reference Line

cuevasj — Tue, 11 Jul 2017 17:46:46 GMT

I have a bar chart with three clusters: District Avg, School Avg, and Student Avg. I then group by (using lattice columns) School Year, and Grade. I need a reference line that is dynamic because the Proficient Level changes from grade to grade.

Any ideas?

(I have attached a picture of what I would like the graph to look like when I'm done.)

Re: Dynamic Value on Reference Line

FredrikE — Tue, 18 Jul 2017 10:27:43 GMT

Add it to the data 🙂

Fredrik

Re: Dynamic Value on Reference Line

cuevasj — Tue, 18 Jul 2017 11:16:14 GMT

I do have it in my data. The question is how to add a value to the graph when the value changes based on grade level since the reference line only allows a numeric value and not a variable value.

Re: Dynamic Value on Reference Line

FredrikE — Tue, 18 Jul 2017 11:57:10 GMT

Hm, maybe I don't follow you here 🙂

My thought was to add a meassure with your reference, and that it has different values depending on dimesnsion etc.

Then use a bar/line chart with the reference as the line, but that is maybe not what you want or isn't achievable that way?

Fredrik

Re: Dynamic Value on Reference Line

cuevasj — Thu, 10 Aug 2017 15:37:53 GMT

A "Bar Chart" object does not allow for a target, only a reference line, and reference lines are not dynamic, they cannot be set to a Measure.

A "Targeted Bar Chart" does not allow for multiple Measures, so I cannot group the student, school, teacher and district results in one graph.

Re: Dynamic Value on Reference Line

VROUSSAKIS — Tue, 05 Sep 2017 11:51:30 GMT

You should create a custom graph with Graph builder that will be combination of a bar chart and a line chart.

Re: Dynamic Value on Reference Line

cuevasj — Mon, 18 Sep 2017 12:16:34 GMT

I tried, but was unsuccesful. Can you walk me through creating a custom graph to do this?