Add a Table Widget to Show Record Details and Create CalculatedColumns
- In the explorer, click Untitled Step and enter the step label.Analytics creates the step ID from the label. After you create the step, you can’t change the step ID. Analytics refers to steps by their ID so dashboards don’t break if you change the labels.
- .
- Select and then choose the table type.Values tableUse to show dataset fields as columns. You can add, remove, and reorder columns. You can also add filters.Compare tableUse 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 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 tableUse 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 show totals in a values or compare table, clickand then select Show Summary.
- To increase the number of records that appear in a values table, 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 Analytics SAQL Reference.
- Click Done.The widget shows the table and results. Analytics adds the step to the steps panel.