Alright so I had my chart working properly up until I attempted to put the links into it.
First I attempted to just define multiple filters based from the data however, it never hit the second filter.
My next thought is to attempt the url definition as i found in Chart from a union query from @"fac586".
I can not figure out what I am not defining properly. When I attempt to use the union all its gives me the missing select keyword.
So I went back and used the order by and now it gives the error of ID not found when i attempt to execute the link.
All other information that should be relevant or needed can be found in .
I apologize for reopening another question when I probably could have just put it in the old thread.
Also, I would like to add a where statement based on if all the records are validated do not display, if possibly to make the chart as automated as possible. My SQL is the one that @"fac586" had suggested in the previous post.