Explore Data with Tables

You can use tables to get a view of the data that is close to the underlying dataset, and you can use tables to manipulate and extend the data to expose fresh insights. With values, compare, and pivot tables, CRM Analytics gives you options for both of those goals.

• Manage the View of Data in a Values Table
  The values table displays all the columns in your dataset. You can customize the view of columns in a values table, and you can sort the row values using any column except for the index column.
• Navigate Compare Table Columns
  Create columns and navigate between existing ones using clicks or keystrokes.
• Organize and Summarize Data in a Pivot Table
  To identify patterns in large amounts of data quickly, arrange the data by a key dimension in a pivot table. For deeper comparative analysis, you can group the pivoted data further and then add row and column totals, subtotals, and grand totals to the pivot table. To evaluate data in a pivot table based on ranking, sort a measure for a pivoted dimension in ascending or descending order (beta).
• Add Custom Formulas to Columns
  Use the column editor to define custom formulas in compare tables or charts. View measures side by side, and perform math across the table’s columns and rows. Use string values to create labels, concatenate dimension values, provide simple buckets, or add image URLs.
• Window Functions Available in the Compare Table
  The compare table's function menu provides UI-based access to useful window functions, saving you the time of having to write them in SAQL. Once you choose a function, you can edit the generated SAQL in the formula editor.
• Use Raw Field Names in Query Formulas
  When writing compare-table formulas, you can reference measure and group (dimension) columns by name. Referencing measure and group columns by name lets you write more intuitive and easily understandable formulas. Even better, the formula editor includes nifty function and formula pickers that save you time as you enter your SAQL formulas.
• Table Properties
  Use table properties to control a table's appearance.
• Column Properties
  The Column Properties panel lets you jazz up the columns you want in compare, values, and pivot tables. To highlight data that meets specific criteria, set conditional formatting rules on a column. Or, highlight data based on conditions set on a reference column. To make a column stand out without applying any conditions, you can use text alignment and text styles. In addition to displaying data in the text format, you can set a measure column’s data type as a bar.