Foresight Analytics Platform allows to set up various table formatting: formatting styles, manual formatting for areas, conditional formatting. If there are several formatting settings, they are applied in a certain order.
Data formatting is set for:
Data table of express report
Data table of dashboard.
Table visualizer and data area .
In the data formatting order, each next item overlaps the previous one:
Data distribution interface. Overlaps only cell fill.
Metrics Color, Font Color, Font Size.
Conditional formatting interface. Overlaps only cell fill.
In manual formatting and conditional formatting format can be set for different table elements, in this case the order of applying of format is the following:
Entire table. The lowest priority.
Data.
Row dimension.
Level of row dimension.
Single row.
Column dimension.
Level of column dimension.
Single column.
Totals by columns.
Totals by rows. The highest priority.
NOTE. On selecting several dimensions by rows or columns, format of the last selected dimension is used.
Manual fill setup of row dimension will be overlapped by separate column fill, but conditional formatting configured for the row will overlap any manually configured fill.
The Time Series Analysis tool has the following formatting settings in the order of application:
On working with data area of regular report the main formatting is data area formatting and totals formatting.
On formatting the table the data area formatting, formula area formatting, totals formatting and the formatting of calculated factors can be overlapped by other styles but by clicking the Refresh button the formatting is set up according to the data area parameters.
See also: