Using the metadata grid, you can rename the remote fields.
Create a bar chart using field college and Math. Change the Math aggregation to AVG.
Drop the Verbal field to Y axis, to create the combined axis chart. And change the aggregation
to Avg.
Follow the same for Writing field.
Now from the Analytics menu, drop the Distribution band to the view, select the scope as
entire table, and select the value as 70 percentiles.
Your view will look like this:
70 percentiles are 547.8
Business and public affairs have all the individual subject values lesser than 547.8.
Elvera
1 days agoLavonda
2 days ago