• Masking Payment Methods
• Creating a BI Query
• Working with BI Criteria
  • Searching for BI Criteria
  • Adding Criteria to a BI Query
  • Example - Customer Query
  • Using Relative Dates and Times with a BI Query
  • Deleting BI Criteria
• Working with BI Filters
  • Searching for a BI Filter
  • Adding a Filter to a BI Query
  • Example Session Filter - Filtering Customers by Create User
  • Example Filter - Filtering Performances by Venue and Date Range
  • Deleting a BI Filter
• Working with BI Formulas
  • Creating a BI Formula
  • Modifying a BI Formula
  • Deleting a BI Formula
• Working with Result Members
  • Adding New Result Members to a BI Query
  • Sorting, Grouping or Totalling Result Members
  • Sorting Results by Data Not Included as a Result Member
  • Defining an Aggregate Function
  • Creating a Pivot Extract (Display Types)
    • Example Pivot Extract -- Customers with Same Last Name in Same City
    • Example Pivot Extract -- Sales by Postal Code
  • Deleting Result Members
• Running a BI Query
• AudienceView Charting
  • Creating an AudienceView Chart
  • Example Chart BIs
  • Modifying the Chart Output
  • AudienceView Charting Options
  • Working with AudienceView Charts
  • Saving an AudienceView Chart
  • Printing an AudienceView Chart
  • Emailing an AudienceView Chart
• Saving a BI Query
• Saving a BI Query to a Folder (Custom Searches)
• Scheduling a BI Query
  • Configuration of the Business Intelligence Scheduler
  • Scheduling Business Intelligence Queries
  • Defining the Number of Concurrently Scheduled Queries
• Creating a Customer Correspondence Extract (Prior to AudienceView 6.8.10)
• Joining BI Queries
• Copying a Saved Query
• Deleting a Saved Query

The date fields that are available in BI criteria are enabled to handle relative dates. Relative date fields are used to enter an amount of time relative to the current date/time (e.g. from 5 days ago through to today).

By default, the date fields in business intelligence criteria are date/time fields. This means that when you enter a relative date, it is relative to the current date and time. For example, if the current date/time is 2017-06-28 14:00:00 and you enter -2D to 0D, you are asking for results from 2017-06-26 14:00:00 to 2017-06-28 14:00:00.

If you prefer to ignore the current time when you specify a relative date, you can modify the criteria in the Registry. If you make this modification, entering -2D to 0D relative to the date 2017-06-28 would return results from 2017-06-26 midnight to 2017-06-28 inclusive.

To change the date/time criteria, refer to Modifying Date and Time Criteria.

Example Relative Date Ranges

• Yesterday: -1D =0h =0m =0s to =0D =0h =0m =0s
• Today: =0D =0h =0m =0s to =0D =0h =0m =0s
• Last Day of Current Month: =31D = 23h =59m =59s
• Any Time This Month: Greater than or equal to =1D =0h =0m =0s to less than or equal to =31D =23h =59m =59s
• Any Time Next month: Greater than or equal to +1M =0D =0h =0m =0s to less than or equal to +1M =31D =23h =59m =59s