What are cross tabs, and how do I use them?
Environment:
Analytics, Report Display Options
Oracle B2C Service, All supported 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.
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:
- incidents.queue_id
- DATE_FORMAT(incidents.created, "MM-YYYY")
- 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.
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 the Online Help User Guide documentation. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.