Formatting a Table
Total And Sub-Totals
No table of figures entries was found.h1. Formatting a Table You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they ...
Grand Total
The Grand Total formatting option is available in the Cross Table widget. By default, the Grand Total formatting options are not visible. Turn the toggle button ON () to use the Grand Total formatting options. The table given below describes ...
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. You can ...
Stepped Layout
In RubiSight, you can plot a Cross Table using multiple features from the dataset. A Cross Table contains the following configuration options. Rows Columns Values The Stepped Layout option is available under Row in Cross Table formatting options. ...
Row
The Row formatting option appears under Cross Table. The table given below describes different fields present on Row formatting. Field Description Remark Header Font It allows you to change the appearance of the Header row. You can change the text ...
Total
The Total formatting option is available in the Table chart. The table given below describes different fields present on Total formatting. Field Description Remark Label It allows you to select the label you want to assign for the Total column. — ...
Highlight in Table
The Highlight option is used for the conditional formatting of a widget. You can change the look and feel of the widget based on conditions that are configured. The conditional formatting explained here highlights various data values present in table ...
Page Navigation On Same Dashboard
Suppose you are viewing a particular page of the dashboard. For a widget on that page, there is a reference to another page in the same dashboard. In this case, you can create and give a hyperlink of that page on the current page. When you click the ...
Hyperlink on Email
You can also use an Email address as a hyperlink URL for various columns in all table-type charts. For this, you can Select a dataset containing the email address(es) associated with each row. Create a Calculated Column containing email address(es). ...
Apply URL
The Apply URL formatting option allows you to apply URLs for columns in your dataset. You can apply URLs that point to external websites or different dashboards. This option is available under Column option in Table, Cross Table, and Sparkline charts ...
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: ...
Column
The column formatting option is available in widgets that contain Tables. The table given below describes different fields present on Column formatting. Field Description Remark Header Font Font of the Header row — Background Color It allows you to ...
Grid
Grid formatting option is available in widgets that contain Tables. By default, the Grid formatting options are not visible. Turn the toggle button ON () to use the Grid formatting options. The table given below describes different fields present on ...
Table Style
When you select a table style, you choose the way the table should appear. The table styles are explained in the table below. The table given below describes different fields present on Table Style formatting. Field Description Remark Style It ...
Formatting a Table
You can format the tables that appear in various charts. Tabular data appears in the following widgets. Table Cross Table Sparkline Chart