Data Bindings - Chart
To get data into your dasharea, you need to select a Bizview dataview. Before you can select a dataview, you need to design one. To design a data view, select the System icon from the menu and then scroll to the bottom and select Data Views:
For more information, see Data View.
Once you create a Bizview dataview, you can select the desired dataview from the drop-down in Data Bindings in the right panel:
Only dataviews with defined dataview fields will be visible in this list.
If you have an existing dataview from an earlier version of Bizview, go to Data view Fields and save the dataview to make it visible in the Dashboard module.
All available dataview fields display in a list to the left of the right panel. You can scroll in the list if there are many dataview fields, and there is also a filter function where you can search by writing the name of the desired field. Drag and drop the desired dataview fields to a container to the right, as demonstrated below:
Below is a list of Data Binding containers for Charts:
Container |
Description |
|---|---|
Value |
The Value container should contain a measure field from the dataview. Measure columns are marked with a Σ sign. |
Argument |
The Argument container should contain the column that you want as argument in your chart. For example, in a bar chart the column that should be stated on the x-axis. |
Series |
If you want the chart to be divided into several series, drag that column to this container. For example, if you want one bar for each year, then you should add the Year column from the dataview in this container and Bizview will automatically create one series for each year returned by the dataview data. |
|
Hidden
|
The Hidden container can be used if you want to use more columns from the dataview in the chart. For example, you want to sort the data in the chart by a column not added in the value, argument or series container, then you add that column in the Hidden container and it will then be available in Field Sortings. Another example is if you want to filter the data by a column not added in the other containers, then that dataview column should be added to the hidden container and can then be filtered by in the Filters section. |
Once you drag and drop the desired fields, the dasharea updates with the data you selected.
You can trace the bound data to view the actual data returned to the dasharea by selecting the corresponding icon:
For more information, see Trace.
Edit the field options by clicking on the fields in the containers in the right panel, as demonstrated below:
The following field options display, depending on the type of chart:
Setting |
Description |
|---|---|
Aggregation Type |
Select desired aggregation type (Sum, Average, Count, Max, Min). By default, the aggregation type is SUM for measures and is shown in the value container next to the column name (within brackets). |
Chart Type |
If you have several values, you can select different chart types for the measures here. |
Color |
Select the color of the chart (overrides palette in General Settings). To undo a selected color, erase the text in the color picker text box. |
You can also click on the argument column and change the following settings:
Setting |
Description |
|---|---|
Aggregation Type |
Select desired aggregation type (Sum, Average, Count, Max, Min). |
Next to the Dataview drop-down there are two buttons:
Update the selected dataview.
Trace can be used as a tool for the Dashboard Designer and/or for troubleshooting purposes. For more information, see Trace.