Skip Navigation
Expand
Cross Tab Basics
Answer ID 8711   |   Last Review Date 11/18/2018

What are cross tabs, and how do I use them?

Environment:

Analytics, Report Display Options
Oracle B2C Service, All versions

Resolution:

Cross Tabs are a feature of reports that allow you to compress & compile data into a few lines that could otherwise take pages of space on your screen. They can help to give a big picture view of your data.

Cross Tabs are accessed while editing a report on the Display tab, in the Options section.

Cross Tab

You will need at least three columns in order to create a Cross Tab. Columns are first added to the report as normal, and then added to the Cross Tab.

Example:

With these three columns in the report:

  1. incidents.queue_id
  2. DATE_FORMAT(incidents.created, "MM-YYYY")
  3. COUNT(incidents.created)

The Cross Tabs could be configured as:

  • ROW FIELDS = incidents.queue_id.
    What to use for the highest level Group By.
    In this case, the incident queues.
  • COLUMN FIELDS = DATE_FORMAT(incidents.created, 'MM-YYYY').
    The rows to display / the sub-groups.
    In this case, the months in which incidents were created.
  • OUTPUT FIELD = COUNT(incidents.created).
    The data for each sub-group.
    In this case, the number of incidents created in each month.
Example output might be:
 Queue

 Created Count

 --  06-2016  07-2016  08-2016
 Adventures 10536 8472  9548 
 World Saving  25 105  42
 Ring Destroying  0 1 0


Note:

Cross Tabs can interact with columns in the report whether or not they are used in the Cross Tab itself, and even if hidden. Any column which is not used, should be removed from the report. Drill-downs (Creating drill-down reports) are an excellent way to dive deeper into your data from an upper-level Cross Tab overview.


For additional information, refer to the 'Define a cross tab report' section in online documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.