4 Replies Latest reply on Oct 2, 2012 4:13 PM by beckettsolutions

    Charting Break Field

    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

       

      Anth