Tables are the simplest way to visualize your data. Any combination of datafields is possible. This means a visualization is always possible, regardless of which datafields from the list are dragged into the columns- and rowsbar. In the example table an overview of applications and corresponding financial information is configured. Moreover the data is filtered based on a specific attribute. This table is very useful for exporting data from bluedolphin in excel or any other format.
In the example below three datafields from the "Fields" category have been dragged to the columnsbar. Each datafield now has a column in the table. The order of fields in the columnsbar determines the order of columns in the table.
Datafields from the measures category can also be added to the table.
The table is now displaying a large amount of objects that are not relevant in the overview that we are creating. To only show financial information about software related objects, we need to define a filter for the 'Object type' field. We can do that by right-clicking on the 'Object type' field and choosing 'Create Filter'. A new filter will appear in the right column of the screen. We can choose what kind of filter it should be by clicking 'equals'. We are going to select 'is one of', which allows us to filter out a selection of object types. When the filter is ready, the 'Apply' button below the filters will activate all filters.
When a datafield is dragged into the groupsbar, all columns will display values grouped into whatever values the datafield in the groupsbar contains. In the example below we are using the 'Object type' datafield to group financial information.
The table is now finished, but it is only showing sample data. We need to change the 'Sample data' option to 'Full data' to display the complete set of data. The sample data option is very useful when configuring a report, because it allows for quick interaction. When configuration is finished, keep in mind to always switch to full data.