Page History

To add a new Table, hover over free place and click on Table view type. The Add a table dialog box will appear.

1. Enter name of the new table.
2. Check Date interval if you need to restrict time period of displayed data - continue by Setting Date Interval .

Confirm new Table view by clicking on a green Continue button. BellaDati will guide you through additional setup.

• Indicators: select and edit displayed indicators in the table - continue by Displaying Indicators .

Table management

You can perform additional operations in the upper right corner of the inserted Table view:

• Table settings
• Indicators
• Table appearance
• Filter setting - continue by Static Filters
• Export view - available in view mode only, continue by Exporting View
• Add to dashboard - available in view mode only
• Duplicate table
• Delete table

Table settings

Click on toolbox icon or select Table settings from the toolbox list to enter Table settings dialog.

Table settings dialog shows Time, Indicators and Drill down paths currently positioned at X and Y axes (horizontal and vertical header). BellaDati allows you to:

• Swap horizontal and vertical header clicking on Swap
• Switch between horizontal and vertical position. This allows you to move one element from the horizontal header to vertical header and vice versa.
  
• Change order within axis.
  
• Remove drill down path.
• Enter indicators or drill down path dialogs.

• Editing Table Axes Content
• Add custom members
• Edit table appearance.

Managing drill-downs

Hover your mouse over the drill-down header to display drill-down management box. This box allows you to:

• add new drill down to the table ("+" sign)
• remove drill down from the table ("X" sign)
• change position of drill-downs in the table ("<" and ">" signs)
• expanding all drill-downs in table ("+" sign in square)
• collapsing all drill-downs in table ("-" sign in square)

Custom member

Custom member allows you adding your own nodes into drill down paths. You can add Custom member from Table settings dialog after selecting Custom members.

Custom member dialog allows you to:

• Select Level for a custom member.
• Specify Name of the custom member.

Every new node requires additional definition. Custom member definition dialog allows you to determine attribute values from particular levels which will be aggregated into custom member.

Table Appearance

You can access Table Appearance from the Table Settings dialog or the from toolbox drop down list.

Table Appearance dialog allows:

• Applying predefined Content color themes.
• Setting Title Color.
• Checking Even and odd rows differentiation.
• Hide drilldown cell controlls: Drill-down "+" signs will be disabled for all drill-downs in the table (useful for "static" item lists etc.).
• Selecting Drill down depth shading. When enabled, each drill-down level is highlighted with a different color shade.
• Force column width sets the width of each indicator column. In case the total width of the columns exceeds the width of the screen, a scrollbar is displayed. If the table has too much space, data columns will be wider to take up the remaining space.
• Force left header width allows the user to set the width of the whole drilll-down area when standard drill-down (not date or time) is used. When there are multiple drill-down attributes in the table, the width is applied to all of them together. In case the width of the columns exceeds the width set in the table appearance, a scrollbar is displayed.
• Set sort indicator and its aggregation.
• Format priority - If you are using table with formula in one axis and indicators on second axis, you can specify which of them will have priority with output format. Formatted row/column has priority over non formatted. If two formatted axis collide. This settings will set priority.
• Simple table - We have created new custom table renderer, that uses simplified version of table, with pagination and easily applied custom CSS.
• Hide filter function will hide static and view filters. View
• Hide static filters will be still displayedfunction will hide static filters in view.
• Prevent to Do not refresh on data change. When this is activated, page must be refreshed first to apply this change.
• Move your view Title at bottom of the view.
• You can remove empty rows after table is rendered. If you are using formulas, they should return NaN. This is best to use with Do not merge same members. Removing empty rows is done after table is rendered. It may take a second.
• Using Custom renderer which is defined in a BellaDati extension (available since BellaDati 2.9.4). See Using Custom Table Renderer for more details.

Displaying Source Data

See how it works.

Static Lists

BellaDati allows you to list attribute members without any indicators in form of a static lists. In order to create static lists:

1. Create new Table
2. Select arbitrary Indicator.
3. Choose desired Attributes.
4. Remove Indicator from the table.
5. Optionally hide drill-down controlls in Table Appearance.
6. Optionally prevent BellaDati from merging same members in Table Appearance.

Setup export layout

To see how setup your own export layout (custom row height, column width, table header, data formatting or merged regions), proceed to separate page.