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

Data Bindings - Pie 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 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_pie_bindings

    Data binding containers:

    Container

    Description

    Value

    The Value container should contain a measure column 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.

    Hidden

     

    The Hidden container named Hidden can be used if you want to use more columns from the dataview in the chart. For example, to sort the data in the chart by a column not added in the value or argument container, 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. For more information, see Trace.

    Dashboard_design_pie_chart

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

    Dashboard_design_pie_measure_opt

    Additional options display, depending on the type of area (area type pie chart in this example):

    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).

    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:

    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 - Pie 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 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_pie_bindings

    Data binding containers:

    Container

    Description

    Value

    The Value container should contain a measure column 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.

    Hidden

     

    The Hidden container named Hidden can be used if you want to use more columns from the dataview in the chart. For example, to sort the data in the chart by a column not added in the value or argument container, 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. For more information, see Trace.

    Dashboard_design_pie_chart

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

    Dashboard_design_pie_measure_opt

    Additional options display, depending on the type of area (area type pie chart in this example):

    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).

    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:

    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