Your first steps with Dataflows

Data sources communicate with source systems of all kinds and deliver the data mostly in form of a table. To display this data, you can either access it with the controls or use a script to process it first. Read here how Postprocessing table data works or how to manipulate table data. In this article you will learn how to post-process various data with little scripting knowledge using dataflows. With dataflows you can for example

Dataflows allow you to start from a single table and gradually adjust the data set until the result meets your needs. You can review, change, and add to the individual steps for each dataflow in the Peakboard Designer. This makes it easy to check whether the sequence has the desired effect, and the expected result appears.

Create a new dataflow

Click on […] next to [Dataflows] or your [Datasource] in the explorer to create a new Dataflow.

Create a new flow

Next, select your base table (1) and confirm via [OK] (2). Even if several tables are involved in the data transformation at the end, the dataflow always starts with exactly one table. Use the text field (3) to assign a unique name for easier identification of the dataflow.

select main table

Now all preparations are done. Via [Add Step] (4) further transformation steps can now be applied to the table. In the right area of the dialog all already applied steps are listed. Of course, they can be changed or deleted later. Click on one of the steps and display the state of the data AFTER this step in the dialog area on the left. The dataset in this example is, as you can see in the screenshot below, of course still in its initial state.

Finally, you can set whether the dataflow should be updated together with its source or should follow its own interval (5).

select main table

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

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