Table Context Menu

The column headings of a table and pivot table include a context menu you can use to perform various functions on the table, as described below. Select  next to the column heading name to access the table context menu. The context menu has two tabs:

• The tab lists the functions you can perform.
• The tab lists all the available fields in the data source.
  
  
  
  
  
  
  
  
  
  Possible menu options on the table context menu tab are described below.

Menu Option	Description
Aggregation	Shown only for numeric fields or metrics, this option allows you to change the aggregation method for the field. Valid options are AVG, MIN, MAX, SUM, NONE, or LAST VALUE.
Autosize all columns	This option causes Insights to autosize all the column widths in the table.
Format	Format data or aggregated data in this column.
Format <field>	Use this option to modify the formatting of numeric and time fields for Table visuals.
Format <field> as URL	Format the data in this column as a URL or image.
Group by <field>	This option allows you to group the table by the field represented by the table column.
Granularity	Shown only for time fields used to group the table, this option allows you to change the granularity of the grouped time field. Options vary based on the granularity you define at the source level..
Hide/Show	Shown in columns using aggregation, this allows you to hide or show the label of the metric used to aggregate your data. Shown in columns that include time data, this allows you to hide or show the time zone label.
Include Blanks	Shown only for time fields used to group the table, this option allows you apply even time intervals for the grouped time field. Select this option once to apply even time intervals. Select it a second time to remove even time intervals.
Reset <field> sorting	Shown after you have sorted a column. Select to reset the sort you performed on the unsaved table.
Reset all sorting	Shown after you have sorted one or more columns. Select to reset all sorting you performed on the unsaved table.
Resort other sorting	Shown after you have sorted one or more columns, but not this column. Select to reset all sorting you performed on the unsaved table.
Ungroup <field>	This option removes grouping by the table column.
Wrap Column	Select to wrap the text or data in a column to improve readability.