Home » Categories » CHARTrunner

CR: General Filtering Tips

Revision Date: 2005-09-19

Information:

Use the Filter function to pinpoint the data you are interested in analyzing. CHARTrunner provides a number of options for defining filters. If a data definition includes a filter, "Filter is defined" will appear in blue below the Filtering button.


Date Values
Most databases require delimiters for any date values you use in your filter. Consult the documentation for your database to determine which delimiters are required. Microsoft Access, for example, requires # delimiters for dates in US date format and ' (single quote) delimiters for international date formats. US formatted dates would be entered as #10/18/99#. An international date would entered as '18/10/99'.


Text Values.
Most databases require delimiters for any text values you use in your filter.  In most cases the ' (single quote) delimiter is used for text values, e.g. 'PQ Systems'.  Consult the documentation for your database to determine the proper text delimiter. 

Define a filter
To define a filter:

  1. Click on the Filtering button on the Data definition tab. The Filter for selecting rows from the data will open.
     
  2. If you want to see only the data that falls between a beginning and ending date, use the drop down list called "Select data where the date/time in THIS column" to select a date column.  Then, enter the beginning and ending date values (see above for how to delimit a date value) that define the range of dates you are interested in.  Check the "Inclusive" box if you want to include the beginning and ending dates in the data.
     
  3. If date range is the only filtering criterion, select OK.
     
  4. You may enter up to three user-defined filter conditions. To do this:
     
    A. Select a database field from the drop-down menu.

    B. Specify the type of comparison. Options are:

    =  Equal to
    <  Less than
    >  Greater than
    <>  Not equal to
    >=  Greater than or equal to
     =<  Less than or equal to
    LIKE  Similar to

    C. In the third field, enter the data value on which you want to make this
         comparison. See the comments above for the proper way to delimit
         a date or text value that you enter into this field.

    D. If you specify more than one user-defined filter condition, select AND
         or OR from the drop down menu and repeat Steps A-C.

     
  5. Use the Additional conditions field if you wish to enter your own SQL filter conditions.  The filter conditions you enter here must be in a format such that it can be used in the WHERE clause of a SQL SELECT statement.

To review the filter clause, click on the See WHERE clause button. Click on OK to close the window.

Ref # 697

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: CR1.5 - My control chart data lines are not printing
Viewed 2209 times since Fri, Nov 9, 2007
CR: Data grouping tardiness
Viewed 3248 times since Tue, Oct 6, 2009
CR: CHARTrunner and Open Office
Viewed 2432 times since Fri, Nov 9, 2007
CR: Unable to fully display settings and windows
Viewed 1971 times since Fri, Jan 22, 2010
CR: Charting pass-fail data as a p-chart
Viewed 4526 times since Fri, Feb 29, 2008
CR: Making an X-bar chart with a single data column
Viewed 2110 times since Fri, Nov 9, 2007
CR: Formatting an Excel Date
Viewed 2497 times since Fri, Nov 9, 2007
CR: Charting counted incidents
Viewed 2031 times since Thu, Feb 23, 2012
CR: A simple query pattern for summarizing raw data
Viewed 2960 times since Tue, Oct 6, 2009
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2140 times since Fri, Nov 9, 2007