A table displays data in tabular form, where the header row defines the field names, and all the rest display their values.
A table stores data as a two-dimensional array that consists of columns and rows. Column headers show dimension or measure's names, while cells contain their values. Each row is a set of cells with a value for each column.
A table may also contain a row with results.
Tables are a great tool for detailed analysis of figures and problem detection. However, it takes longer to understand the information from a table at a glance than from a graphics-based chart.
A table is a good choice for quantitative comparison, where you can see different values of multiple categories or dimensions.
Integer, Fractional number, String, Logical, Date, Date and time
Aggregation
Sets the aggregation type
Not editable for this data type.
Format
Sets the value display format
Number: display the values as plain numbers. Percent: show the values as a percentage.
Show delimiter
Toggles the separation of groups of thousands.
Show: display spaces between groups of thousands. Hide: hide spaces between groups of thousands.
Prefix
Sets a text to display before the value
A string of characters.
Postfix
Sets a text to display after the value.
A string of characters.
Units
Sets a rounding scale to apply to the field's values.
Null: don't apply rounding. Auto: select and apply a rounding scale automatically. Thousands, K: round to thousands, display 000 as K. Millions, M: round to millions, display 000 000 as M. Billions, B: round to billions, display 000 000 000 as B. Trillions, T: round to trillions, display 000 000 000 000 as T.
Linear indicator
Toggles a linear indicator display to represent your data in a graphical form.
Please note: the Column fill color overrides this setting.
On: displays linear indicators in the column. Off: hides linear indicators in the column.
Fill type
Selects a color fill type for linear indicators.
One color: displays linear indicators filled with a single color:
Color swatch: displays a pop-up to select a pallette and choose one of the predefined colors from it.
Two colors: displays linear indicators filled with a single color, but colors for positive and negative values are different. The controls are similar as for One color, but these ones are different for the positive and negative values.
Gradient: displays linear indicators filled with a gradient. This control displays a dialog window:
Gradient type toggles between gradients based on 2 or 3 colors.
Drop-down menu selects the gradient color palette. The preview is displayed to the left.
The button changes the gradient's direction.
Set threshold values allows you to specify threshold values manually, each value will correspond to a color.
Show labels
Display values on top of linear indicators.
On: show values. Off: hide values.
Align
Toggles the indicator's starting side.
Please note: this setting works only if all the values in the column are either positive or negative.
Default: the indicator's zero side is selected automatically. Left: the indicator's zero side is on the left. Right: the indicator's zero side is on the right.
Scale
Sets the indicator's scale.
Auto: Visualization sets the scale from 0 to the maximum field value. Manual: allows you to manually set the min and max values for the indicators.
Column fill color
Fills the cells with different colors from a gradient depending on the value.
Please note: this setting overrides the Linear indicator.
On: apply the color fill. Off: remove color fill.
By field
Sets the field from which to get the values for the fill color.
Select the field from the drop-down menu.
Fill type
Selects a color fill type for linear indicators.
Gradient: sets the gradient from which to get the colors depending on the field value.
Integer, Fractional number, String, Logical, Date, Date and time
Aggregation
Sets the aggregation type
No: doesn't apply aggregation. Count: applies the COUNT function to the data field, and shows the total number of entries. Count distinct: applies the COUNTD function to the data field, and returns the number of unique values in the field.
Column fill color
Fills the cells with different colors from a gradient depending on the value.
On: apply the color fill. Off: remove color fill.
By field
Sets the field from which to get the values for the fill color.
Select the field from the drop-down menu.
Fill type
Selects a color fill type for linear indicators.
Palette: displays a pop-up to select a pallette and choose one of the predefined colors from it.
Integer, Fractional number, String, Logical, Date, Date and time
Grouping
Sets the grouping and rounding by time period.
No - doesn't apply grouping. Rounding - rounds the values by Year, Quarter, Month, Week or Day. Date part - returns the number of a time period: Year, Quarter, Month, Week, Day of week, or Day.
Date mode
Toggles the date display mode.
Continuous - display all the dates continuously. Discrete - show only the dates containing values.
No: doesn't apply aggregation. Count: applies the COUNT function, returns the total number of entries. Minimum: applies the MIN function, returns the minimum value. Maximum: applies the MAX function, returns the maximum value. Count distinct: applies the COUNTD function to the data field, and returns the number of unique values in the field. Average: applies the AVG function, returns the arithmetic mean value.