4 Replies Latest reply: Aug 15, 2014 2:06 AM by Dwight Shackelford RSS

    how to filter records for a chart

      I know I can create separate tables to be used for a chart, but I'd like to know how to filter the main table(s) for specific charts.


      I have a list of events, and the profit / loss values for those events, in the main table.


      I would like to create a chart which only works with events where money was lost.  Is there a way, in the chart, to do the filtering without resorting to creating a separate table, qualifying the fields, etc?  I see fields in the chart parameters that say "conditional" but nothing seems to be working.