Charting Break Field

Discussion created by beckettsolutions on Oct 1, 2012
Latest reply on Oct 2, 2012 by beckettsolutions

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