Currently i am trying to chart data in a very large database,
Facilities -> Payment Statements
New Payment Statement comes each month
Theres roughly 1000 facilities and i want a chart to show 2 series' on the 1 chart, 1 for the selected facility and one that shows summary data for the rest of the facilities together (weather or not the selected facility is included it does not matter)
It needs to show data over the course of 12 payment statements (1 year)
Having a few problems grouping the data, when i try and sort it by 'Facility::Selected' then by "Payment Statements::date" it's trying to make the axis 'selected' not 'date'
anyone able to make sense of this one?
Thanks in advance