• 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

Using the Display Type column on the Business Intelligence|Results page, you can create pivot extracts. Pivot extracts enable you to combine and compare result members. Pivot extracts can be useful to analyze related information.

Pivot extracts can only be viewed in PDF and on the Business Intelligence|Preview page.

For example, you can use a BI pivot extract to:

• Analyze sales by payment method to discover how customers are purchasing tickets.
• Analyze customers with outstanding balances to determine how much is owed.
• Analyze customers by their purchases.

A pivot extract is created by defining:

• One result member as your source data (Display Type = data),
• One result member whose data you want to display as a column (Display Type = horizontal), and
• At least one result member whose data you want to display as a row (Display Type = vertical).
• Optionally (as of AudienceView 6.8.11), one result member as your side-total (Display Type = data with side-totals)

When creating a pivot extract, it is important to plan what will be your data, horizontal display and vertical display. It is best to first add your result members and preview the results. Based on what you see in the results, define how you want to analyze your data.

The following pages provide some example pivot extracts:

• Example Pivot Extract – Customers with Same Last Name in Same City
  Describes how to create a BI query that searches customers with the same last name in the same city.
• Example Pivot Extract – Sales by Postal Code
  Describes how to create a BI query that searches for sales by postal code.