Dynamically Filter Line Chart with Formula Queries (or open to better ideas to do this)

Can you tell us a little more about the structure of your app. You may not have relationships, but what are the records that are holding these totals and what are the formulas queries summarizing? What are the sort of child tables.