Pie Chart

Overview

The Pie Chart is used to show percentage or proportional data for each category in the corresponding dataset.


Important: The pie chart displays the dataset as it is. In order to have a better understandable pie chart, adata preprocessing using aggregation is needed. The following example presents two pie charts with and without aggregation.


The dataset used contains rent prices for apartments located both in Passau and Weimar.  


Steps to follow

  1. Create a workflow with a Result Table processor or a Filterable Result Table (FRT)
  2. Create a new report for the workflow
  3. In the report add a new Container by clicking "Add Report Container" or by double-clicking in the empty canvas.
  4. Select a processor with the data that should be visualized
  5. Switch to edit mode
  6. Open the chart menu and change the type Pie Chart
  7. Set the mandatory fields: 
    • Group-By (Category) Column
    • Data (Value) Column


Check the full Demo under Attachements


Configuration

1. Data Manipulation

    Filter shown data. It's possible to add a filter for each column.


2. Group-By (Category) Column

    Select the group by column. Values of this column will be displayed in the chart as categories.


3. Data (Value) Column

    Select the data column. Values of this column will be displayed as partitions of the pie.


4. Description

    Select the column that should be shown as description


5. Label format

    Set the label format (color, font weight, etc).


6. Color

    Change the partitions' color.


7. Format Data

    Used to alter one or multiple columns without changing the corresponding data. Add new Format Groups, select the format and add the target columns.


8. General Chart Container Settings

    Change the background color and and chose whether to display the container title.

















Sunburst Chart

Overview

The Sunburst chart is a multi-level Pie Chart typically used to visualize hierarchical data structures. It consists of an inner ring surrounded by rings of deeper hierarchy levels. The angle of each segment is either proportional to a value or divided equally under its parent node.


Important: Unlike the pie chart, the sunburst chart uses the sum as a default aggregation function. The following figure shows the same previous example using sunburst chart with no preprocessing.


Steps to follow

  1. Create a workflow with a Result Table processor or a Filterable Result Table (FRT)
  2. Create a new report for the workflow
  3. In the report add a new Container by clicking "Add Report Container" or by double-clicking in the empty canvas.
  4. Select a processor with the data that should be visualized
  5. Switch to edit mode
  6. Open the chart menu and change the type Sunburst Chart
  7. Set the mandatory field (nodes)


Check the full Demo under Attachements


Configuration


1. Data Manipulation

    Filter shown data. It's possible to add a filter for each column.


2. Nodes

    Select columns to add nodes that should be visible in the chart.

    The last node needs to have numeric values.


3. Values

    Option to use COUNT for leaf sizes instead of values.


4. Labels & Legend

    Show/Hide labels and legends.


5. Color

    Change the partitions' color.


6. General Chart Container Settings

    Change the background color and and choose whether to display the container title.