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

I often have to compare, for example, teacher - school - district averages. Does anyone know how to do this in VA? Currently, I am pre-summarizing my data in eg, then moving the table up to LASR to use. However, what I would like to do is have one table then be able to average by teacher, by school, and by district.

 

example dataset columns:  school_number student_number teacher_number score

 

In VA, I need to have a drop-down for the principal to select their school, then select the course, and finally select a teacher. 

Once this is done and the selections are made, I have not been able to figure out a way to find the average for the school or district.

In education, we often need to compare how a specific teacher is performing compared to school and/or district.

 

using VA 7.3 Hotfix 04

1 ACCEPTED SOLUTION

Accepted Solutions
FredrikE
Rhodochrosite | Level 12

That should be possible using the graph builder where you can stack different chart objects on/besid/above each other and even have different aggregations on them. They appear as if they were the same graph.

 

I have done this a coupple of times when I want to compare for exmple different divisions to the total, added two horizontal bar charts, one for the total and one for the different divisions.

I put them above each other and users can easily compare their division to total.

 

Not "out of the box" thou' 🙂

 

//Fredrik

View solution in original post

3 REPLIES 3
FredrikE
Rhodochrosite | Level 12

I think you could do this with drop-downs and parameters.

Instead of placing the drop-downs on the report or section area, you place them on the reporting area.

 

You then need to create your own filter that uses the parameters for filtering the graphs, but in this way you can choose to filter one graph on school and another one on teacher and in that way compare teacher to school 🙂

 

I think you need at least 7.4 for full funktionality of the parameters.

 

//Fredrik

cuevasj
Quartz | Level 8
I appreciate your response, but Visually, the data looks much better in a clustered barchart (for example) where the end user can quickly make a comparison.
FredrikE
Rhodochrosite | Level 12

That should be possible using the graph builder where you can stack different chart objects on/besid/above each other and even have different aggregations on them. They appear as if they were the same graph.

 

I have done this a coupple of times when I want to compare for exmple different divisions to the total, added two horizontal bar charts, one for the total and one for the different divisions.

I put them above each other and users can easily compare their division to total.

 

Not "out of the box" thou' 🙂

 

//Fredrik

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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