AnsweredAssumed Answered

Charting problem (break field)

Question asked by beckett85_1 on Oct 1, 2012
Latest reply on Oct 2, 2012 by philmodjunk


Charting problem (break field)


     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', 1 for the selected facility and one that shows summary data for all 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::Yearmonth_n" it's trying to make the axis 'selected' not 'yearmonth'


     anyone able to make sense of this one?