Hi, I am using a dataset aggregated by Judicial Circuit (there are twenty in FL) I need to create a dashboard which filters (globally)by circuit and allows me so present data for the circuit compared to the Statewide average on the same chart
I found the answer to my own question!
First, I put Circuit on the Page Shelf
I used a calculated field with the - TOTAL([field]) calculation then added it to my chart and selected "Calculate by/Circuit". I get a Statewide average and the Circuit average line side by side and I can use the playback function of the page control and make a "movie"!