I want to make a line graph that has two lines. The dimension will be the Year. When you click on a specific unit, one line will show that units total Type B value for each year, and a second line will show the average county type B value for each year. Below is a small sample of the data. There are more units, and counties that just this.
It is coming from a server, so I can only get some of the data. There is a lot more, but this sample size shows everything I am dealing with. I would love for the graph to show the total unit average per year for type B before I select a unit. Then split into county and unit lines once selected. If that isn't possible i can always just put in a formula into the data handling part of the graph to require the user to select a unit, and then two lines populate.