Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Data Bindings - Grid

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 dataview, access SYSTEM ADMINISTRATION > Data Services > SETUP > Data Views in the Silverlight Client. 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:

Dashboard_design_select_dataview

Note:
    • Only dataviews with defined dataview fields will be visible in this list. To define dataview field, navigate to the Silverlight Client.

    • 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. Drag and drop the desired dataview fields to a container to the right.

    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.

    Dashboard_design_grid_bindings

    Data binding containers:

    Container

    Description

    Column

    The Column container should contain all the columns from the dataview that you want to include in the grid.

    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. For more information, see Trace.

    Dashboard_design_grid

    Edit the field options by clicking on the fields in the containers in the right panel:

    Dashboard_design_measure

    The following options display:

    Setting

    Description

    Aggregation type

    Select desired aggregation type for the measure columns (i.e  Sum, Average, Count, Max, Min). By default, the aggregation type is SUM and is shown in the Column container next to the column name (within brackets).

    Text alignment

    Select the desired alignment of the text.

    Format type

    Select format of the measure:

    • Fixed point - Show the exact value

    • Percent - Show values in percentage

    • Thousands - Show values in thousands

    • Millions - Show values in millions

    Precision

    Select precision of the measure (number of decimals (0-10)).

    Grouping index

    To group data by the values of a given column, set the column's Grouping Index to a non-negative integer. If several columns are involved in grouping, the Grouping Index property specifies the grouping level. If set to 0, the column is at the root grouping level. Note that changing the Grouping Index value updates this property value for other columns involved in grouping.

    In the above example, we want to group the value per Product Line. We would then mark the Product Line column in the Column Container and change the grouping index to "1". The values in the grid will then be grouped by product line. If we want to add another grouping under Product Line, we could mark Product Group and change the grouping index to "2". Then, the data would first be grouped by Product Line and under each Product Line be grouped by Product Group.

    Summary type

    Displays a summary row at the end of the grid for selected columns. Select desired sum type (Sum, Average, Count, Max, Min). If using grouping index, a total amount will also be visible for each grouping.

    Next to the Dataview drop-down there are two buttons:

    Dashboard_design_measure_opt

    • Dashboard_design_update_dataview_list Update the selected dataview (after changes made in the Silverlight Client, for example, after adding a field or creating a new dataview).
    • Dashboard_design_view_trace_dv Trace can be used as a tool for the Dashboard Designer and/or for troubleshooting purposes. For more information, see Trace.

    Published:

    Data Bindings - Grid

    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 dataview, access SYSTEM ADMINISTRATION > Data Services > SETUP > Data Views in the Silverlight Client. 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:

    Dashboard_design_select_dataview

    Note:
    • Only dataviews with defined dataview fields will be visible in this list. To define dataview field, navigate to the Silverlight Client.

    • 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. Drag and drop the desired dataview fields to a container to the right.

    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.

    Dashboard_design_grid_bindings

    Data binding containers:

    Container

    Description

    Column

    The Column container should contain all the columns from the dataview that you want to include in the grid.

    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. For more information, see Trace.

    Dashboard_design_grid

    Edit the field options by clicking on the fields in the containers in the right panel:

    Dashboard_design_measure

    The following options display:

    Setting

    Description

    Aggregation type

    Select desired aggregation type for the measure columns (i.e  Sum, Average, Count, Max, Min). By default, the aggregation type is SUM and is shown in the Column container next to the column name (within brackets).

    Text alignment

    Select the desired alignment of the text.

    Format type

    Select format of the measure:

    • Fixed point - Show the exact value

    • Percent - Show values in percentage

    • Thousands - Show values in thousands

    • Millions - Show values in millions

    Precision

    Select precision of the measure (number of decimals (0-10)).

    Grouping index

    To group data by the values of a given column, set the column's Grouping Index to a non-negative integer. If several columns are involved in grouping, the Grouping Index property specifies the grouping level. If set to 0, the column is at the root grouping level. Note that changing the Grouping Index value updates this property value for other columns involved in grouping.

    In the above example, we want to group the value per Product Line. We would then mark the Product Line column in the Column Container and change the grouping index to "1". The values in the grid will then be grouped by product line. If we want to add another grouping under Product Line, we could mark Product Group and change the grouping index to "2". Then, the data would first be grouped by Product Line and under each Product Line be grouped by Product Group.

    Summary type

    Displays a summary row at the end of the grid for selected columns. Select desired sum type (Sum, Average, Count, Max, Min). If using grouping index, a total amount will also be visible for each grouping.

    Next to the Dataview drop-down there are two buttons:

    Dashboard_design_measure_opt

    • Dashboard_design_update_dataview_list Update the selected dataview (after changes made in the Silverlight Client, for example, after adding a field or creating a new dataview).
    • Dashboard_design_view_trace_dv Trace can be used as a tool for the Dashboard Designer and/or for troubleshooting purposes. For more information, see Trace.

    For an optimal Community experience, Please view on Desktop
    Powered by Zendesk