Tabular Reports

Tabular reports displays your data in a tabular format rather than a chart. Create the tabular report from an existing visualization report or start with a new one.

Note: Visualizer tabular reports can be exported as Excel or PDF. Crosstab reports can be exported as Excel pivot tables.

Learn how to:

Create a table from an existing visualization

Create a new table

Create a break

Create a table from an existing visualization

  1. In Edit mode, click a report then click Edit.
  2. From the edit menu, click 'Edit in Visualizer'.

  3. On the toolbar, click 'Change Visualization' and then select 'Table'.

    The table displays.

  4. Modify the table settings using the information in Create a report
  5. To save the table, click Save As and enter a new name.

Create a new table

  1. If Visualizer is not already empty, click 'Create New Chart'.

    Or, if you are in the edit mode, click Insert > New Report.

  2. On the toolbar, click 'Change Visualization' and click 'Table'.

  3. The message on Chart Builder tells you to add attributes and measures. For tables, measures and attributes are put into 'Columns'.

  4. From 'Subject Areas', drag and drop measures  to the Columns tab.
  5. Click Save.
  6. Continue formatting the table (see Formatting Data).

Create a break

Select the column attribute you want to create sections for, then:

  1. click the drop-down arrow

    and select 'Break By'.

The report will create a sub-section based on the break for the attribute you selected.

Click the down arrow to expand and collapse all breaks by sections.

Tips:

  • Underneath the table, Visualizer displays the number of rows returned.
  • By default, Visualizer limits the number of rows to 100. This is for convenience while designing as well as for performance reasons. You can change this in the 'Top N Results' menu.
  • When there are a lot of rows in a table Visualizer automatically adds a scroll bar. The size of the scrolling area is based on the size of your browser window.
  • By default Visualizer adds a Grand Summary at the bottom of measure columns. To toggle this option, click Table Settings > Grand Summary > Column Summary.
  • If the text or numbers in a column exceed the column width, hover over the column and a tooltip displays the full text or all of the number.
  • Visualizer has a 50,000 row limit for tabular data.