Values
Values formatting option is available in the Cross Table widget.
The table given below describes different fields present on Values formatting.
Field | Description | Remark |
|---|---|---|
Header Font | It allows you to change the appearance of the Header row. |
|
Background Color | It allows you to change the background color of the header row. | — |
Alignment | It allows you to change the text alignment of the header row. | You can align the text to Left, Centre, or Right. |
All Values Font | It allows you to change the appearance of the table rows. |
|
Background Color | It allows you to change the background color of the table rows. | — |
Alignment | It allows you to change the text alignment of the table rows. | You can align the text to Left, Centre, or Right. |
Width | It allows you to change the width of the selected row. | — |
Height | It allows you to change the height of the selected row. | — |
Word Wrap | This toggle button helps you to turn the word wrapping ON or OFF. | — |
To use Values formatting options, first plot a Cross Table chart the measures from the dataset. For example, we plot a Cross Table Chart of Average of Income and Average of Cards.
The figure given below shows an original image of the Cross Table Chart.
Next, change the font type, size, background color, alignment of the values in the Header row.
The resultant widget is shown below.
Next, we change the All Values formatting options.
Related Articles
Merge Same Values
The Merge same values option allows you to merge rows containing same values for the selected dimension. This option is available under Column option in Table, Cross Table, and Sparkline charts and is visible only after you select a column. Note: ...Top N Bottom N
The Top N/Bottom N refers to the top (highest/largest) N values and bottom (lowest/smallest) N values or ranks in the aggregated values of the selected measure in the dataset. For example, if N = 15, then corresponding to a particular variable, we ...Show blank as zero
Showing blanks as zero in widgets Show Blank as Zero functionality allows you to represent Null values as zero in widgets. It is available in line chart, column chart, bar chart, stacked bar chart, stacked column chart, filter widget and table ...Classification
Notes: The Reader (Dataset) should be connected to the algorithm. Missing values should not be present in any rows or columns of the reader. To find out missing values in a data, use Descriptive Statistics. Refer to Descriptive Statistics. If missing ...Using Parameters in RubiSight
In RubiSight, two types of user-defined values are available, Calculated Column Parameters A Calculated Column is created as a new column created that was not a part of the original dataset. The new column is related to one (or more) of the existing ...