Creating a Table in Visualizer
You can view data in a tabular format rather than as a chart. Create a table from either an existing visualization report or make a new one.
Tip: Switching to table mode on an existing chart is a great way to preview the underlying data.
To create a table from another visualization
- Open an existing
visualization report in Visualizer. For example, Revenue by Quarter and
Region.
- From Guided
Mode select table. Visualizer converts the existing
chart to a table.
- Click Save As and save the table with a new name.
- Continue formatting the table. See Formatting Visualizer Tabular Reports.
To create a new table
- If Visualizer is not already empty, click Create New Chart.
- From Guided Mode select table.
- The Chart
Builder prompts you to add attributes and measures.
For tables, all measures and attributes are put in the Columns section.
- Drag and drop
measures and attributes to the table from the Subject Area.
- Click Save to name and save the new table.
- Continue formatting the table. See Formatting Visualizer Tabular Reports.
To create a break by report
Select the column attribute you want to create sections for, click the drop-down arrow to reveal additional actions and select Break By.
The report will create sub section based on the Break by attribute selected. In this case By Category Name.
Note: It is possible to expand and collapse all Break by sections.
Previously, you could only expand and collapse one section at a time by clicking the hash mark next to the Break by category.
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, you can 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.
- When Grand Summary was enabled and Local Summary was disabled for table and cross tab reports, the Grand Summary for some attributes was incorrect. This calculation error can be resolved by selecting the All - Is Not Missing option from the Table Settings menu.
- Enabling All - Is Not Missing adds an Advanced “IsNotMissing” filter for all the attributes on the report. This filter is dynamic and will update when any attribute columns are added or removed from the report.
- The filter is uneditable and will appear in grey at the top of the Filters bucket in the chart builder
- The filter can be removed either by dragging/dropping it from chart builder or disabling the toggle for the All - Is Not Missing option.