Get started

The first visualization

Now that you know the Peakboard Designer, it’s time to create your first visualization. First, drag and drop a [Text] control from the overview on the right and define various settings in the attributes as well as the appearance of this control. Also choose the desired font, alignment or background, as well as a text to be displayed. This will later be replaced by a data set. Add a [Circular gauge diagram] from the [Diagram] group as your second control and adjust attributes such as size or color in the section [Appearance] for it as well (1).

Peakboard Designer - Controls

1.1 Use resources and images

Use different file types in your visualization such as image files (JPG or PNG), PDFs or attach Excel files. For example, drag your logo as an image file to the explorer or go to the folder menu of the resources folder and add a local resource. Then you can drag and drop the file from the explorer to a free area of the workspace and specify size and position. For other data formats, the process works very similarly.

Peakboard Designer - Drag&Drop

1.2 Connect data source

Easily connect a wide variety of data sources with Peakboard. From data formats like CSV, JSON and XML, databases and SAP to social media and machine, conveyor and sensor information like Siemens S7 and OPC UA. You can find an overview of the different data sources here.

In this example we use a Microsoft Excel file and load it directly into the project. The Excel file contains four products with five properties: title, product number, stock quantity, minimum stock and stock capacity. Download our example file and drag and drop it, just like the image before. Now the file is a resource in the explorer (1). If you later want to include Excel files from other locations, you can find out how to do this here.

Peakboard Designer - Excel resource

Now add the resource as a data source. To do this, right-click on the [Data] folder on the left or click on […] and select [Add data source] and [Excel] (1) from the menu.

Peakboard Designer - Excel data source

Now enter a name for the data source, e.g. [Excel_File] (1) and select the uploaded Excel file in the [Connection] area by clicking on the three dots behind the [File] input field (2). After clicking on [Load Worksheets] (3), define at [Specify Details] which worksheet should be used and if there are headings in the first row like in this example. With [Load data] (4) you can check the data for plausibility.

Peakboard Designer - Excel data source

For the next steps you change the last three columns of the table from [String] to [Number] (1) in the preview area. Then you save with [OK] (2). Voilà, you have just connected your first data source.

Peakboard Designer - Excel data source

1.3 Connect data and control

The last step is to connect the data source to a control. Select a control in the explorer or by clicking on the workspace, in this case the text field. On the right side in the attributes you will find the attribute [Text]. Click on the brackets symbol (1) in this line.

Peakboard Designer - Text data source

Now select the data source and the desired column (Title) and row (1), in this case row 0 and column [Title] for the heading. Note that in information technology counting starts at 0, so row 0 is the first row. The row with the headings is ignored. Confirm with [OK] (2), then the content of this cell of your data source will be displayed inside the textbox.

Peakboard Designer - Text data source settings

Now connect the data source with the gauge diagram. To do this, click on the brackets symbol in the respective row in the attributes (1) and select the Excel data source in each case. Define for the field [Data / Value] (2) the column [Stock_Quantity], for the field [Minimum] (3) the column [Min_Quantity] and for [Maximum] (4) the column [Storage_Capacity].

Peakboard Designer - Gauge diagram

1.4. Preview

You did it! Your first visualization with Peakboard is ready. Click on [Preview] (1) in the menu bar to view it.

Peakboard Designer - Preview Button

A new dialog will open showing you the result. This visualization can now be transferred to your Peakboard box.

2. Next step

If you already have a Peakboard Box, the article The Peakboard Box will help you with your next steps.

If you have problems with the Peakboard Designer, don’t hesitate to contact us. All important information can be found at www.peakboard.com/academy. We wish you a lot of fun and success with Peakboard!

Be enlightened!

Do you need more support?

Peakboard Youtube icon Visit our YouTube channel

Our numerous videos for beginners and advanced users explain exactly how to design your dashboard.

Peakboard Templates icon Visit the Peakboard Templates

Download our templates for various use cases for free.

Peakboard icon Visit www.peakboard.com

Find out all about Peakboard and browse our different use cases and success stories.