Chart Widget

Make your own visualizations for your dashboard with the Chart Widget. Click the + Widget button in the corner of your dashboard when you are in edit mode and select the Chart Widget.

Configure Chart Widget

When you open the Configure Widget window, you have a few different possibilities:

1. Select a saved chart in the list and click save. This will add the chart to your dashboard
2. Edit an existing chart by clicking the pencil. This will open the chart builder
3. Create a new chart. This will open the chart builder
4. Delete an existing chart.

Chart Builder

The chart builder is used to make chart configurations for the Chart Widget. With the chart builder, it is possible to build visualizations based on any data from the Scifeon database.

The layout of the chart builder is split in three:

1. In the top left corner you can see the result of your configured chart
2. Below the chart, you can use the list to filter and sort the data for the visualization
3. In the right side, you will find the chart settings panel.

Data Query

When creating a new chart, you have the option to select a data source from a list of possible tables and views from the database. This allows you to choose the specific data that you want to visualize in the chart.

Once you have selected a data source, such as "Analysis", the data query tab will open and display the data. In this tab, you can further refine the data by filtering the list, sorting the data, and adding or removing columns.

The columns displayed in the list are the available columns that can be used in the chart settings panel. These columns determine the data that will be used to generate the chart.

Chart Settings

In the chart settings panel, you can configure the following for your chart:

1. The title of your Chart
2. The column from your Data Query that is used for the x-axis
3. Flip the axis
4. Behavior for columns
   1. Grouped: Columns are placed adjacently
   2. Stacked: Columns are placed on top of each other
   3. Percent: Like stacked but with sized based on percentage
5. Adding Data Series

Data Series

It is possible add multiple data series to one chart and thereby compare data from the same table. Each data series can be configured to your needs. In the following section, each configuration will be described.

1. The title of your data series
2. The type of visualization.
   1. Column
   2. Line
   3. Use the feedback button to request more
3. Calculation Method
   1. Count Items: Plot the number of rows for the y-axis
   2. Sum: Plot the sum of y-axis values (requires selection in Column for Y-Axis)
   3. Average: Plot the average of y-axis values (requires selection in Column for Y-Axis)
   4. Median: Plot the median of y-axis values (requires selection in Column for Y-Axis)
   5. Min: Plot the minimum of y-axis values (requires selection in Column for Y-Axis)
   6. Max: Plot the maximum of y-axis values (requires selection in Column for Y-Axis)
   7. No Aggregation: Plot the x and y values without aggregating (requires selection in Column for Y-Axis)
4. Column for Y-Axis: A column from your Data Query that is used for the y-axis
5. Group By Date: If the x-axis is based on datetime values then you can group values per:
   1. Hour
   2. Day
   3. Week
   4. Month
   5. Year
6. Group By Column: A column from your Data Query that is used to generate multiple data series with the same configuration.

The following example is using the configuration from the previous image. The data is grouped per month and a data series is generated per unique value from the Procedure column.