Add a Table Widget to Show Record Details and Create Calculated Columns

You can add different types of tables to a CRM Analytics dashboard. To view record-level details, add a values table. A values table can show details like how long a case has been open and who owns it. To create custom columns in a table based on calculations from existing fields, add a compare table. If the underlying query contains at least one grouping, you can create a pivot table.

1. Drag the table widget to the dashboard canvas.
2. To open the wizard, click the button inside the widget.
   One of the following screens appears.

   • The Select a data source screen appears, showing the most recently used datasets first. Select the dataset in the Dataset tab or select an existing query.
     
   • The lens appears, showing a bar chart with the Count of Rows measure. CRM Analytics selects the dataset that you used to create the previous query. To use a different dataset or an existing query, click Back.
     
3. Select and then choose the table type.

   Values table

   Use to show dataset fields as columns. You can add, remove, or reorder columns. You can quick sort on a column by clicking its field header. You can also add filters.

   

   Compare table

   Use to add calculated columns to the table. By default, the table shows the previously selected measure as the first column. You can add measures and filters, and group by dimensions. To quick sort on a column, click its field header. To add a calculated column, click the down arrow next to a measure, and select Clone Column and then edit the new column.

   

   For more information, see Creating Calculated Columns Using a Compare Table.

   Pivot table

   Use to show groupings on the x- and y-axes. The last grouping determines the columns, and the other groupings determine the rows. The pivot table shows the first specified measure in the table cells. To quick sort on a column, click its field header.

   

4. To show totals in a values or compare table, click and then select Show Column Totals.
5. To increase the number of records that appear in a values table, update the Query Limit value or click and change the limit parameter in the SAQL query.
   

   Note By default, the query for a values table widget returns up to 100 results. For more information about the limit parameter, see CRM Analytics SAQL Developer Guide.

   

   When the limit value is increased for a table, pagination is automatically enabled and limits the amount of data loaded up front. As you page through table results, more data loads as needed. To disable table pagination, edit your dashboard and update the widget properties.

   

   If the limit value is increased in the query, the limit value isn’t carried over to the Dashboard Inspector or Show Details, which both return up to 200 results.
6. Click Done.
   The widget shows the table and results. CRM Analytics adds the query to the query panel.
7. To change the widget and query properties, select the widget.

   The Widget panel groups the widget properties into sections. So that you don’t accidentally overlook any properties, expand any collapsed sections.

   
8. To customize the appearance of the widget, go to the Widget tab.
   The widget properties vary based on the table type.
9. To add a tooltip to a table column, go to the Column tab and select a column.
   
   1. Expand the Header section. Click Custom and type in a tooltip.
      
10. To show and set the query properties, click the Query tab.
11. Click the Preview button to see your changes in the dashboard.
12. Save the dashboard.

• Subtotal Considerations for Tables
  The ability to expand and collapse rows, often seen in table widget types such as compare and pivot, depends on the presence and proper display of subtotals. This means that the ability to expand and collapse rows within these tables is closely linked to how subtotals are configured and rendered. And, if subtotals are turned off in a table widget, hiding the first row or column can make the entire table disappear.
• Data Visibility Considerations in Pivot and Compare Tables
  Enabling features such as totals, subtotals, row totals, or column totals in pivot or compare tables can alter data display. These added summary rows expand the result set, which can cause certain values to be excluded if the query limit is too low.