General Principles

User interface

General Principles Add Missing Dates Add text column Add Total Rows Aggregate Append Compare Text Columns Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Custom step Delete column(s) Geographically dissolve data Duplicate Duration Evolution Extract date information Extract substring Fill null Filter Formula Geographical hierarchy Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Moving Average Percentage Pivot Rank Rename Replace Geographical simplification Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Packages Steps Designing a new step Known limitations Variables UI components Custom code editor Python package

General principles

The Visual Query Builder interface breaks down into 2 panels:

the transformation pipeline on the left: this is where you can see the ordered series of transformation steps that are applied to your data. When you need to configure a given step, the left panel switches to the step edition form
the data table on the right: this is where you can click on your data to apply transformations. The right panel also includes widgets above the table. Transformations are available from the columns headers, from the widgets or can be found via the search bar.

Everytime you interact with the table or widgets to transform data, the corresponding step is logged in the transformation pipeline. Any step can be edited or deleted. If a step in the middle of the pipeline gets edited or deleted, the following steps remain unchanged.

If you click on any step of the pipeline, the data table on the right will update to show you the result of the transformations until this step. Following steps get greyed to show that they are temporarily disabled and not executed. In that sense, the pipeline acts as a history that you can navigate into. It can be very helpful when debugging!

You can insert a step in the middle of the pipeline. The general rule is that a step is added immediately after the selected step in the pipeline. So if you want to insert a step in the midlle of the pipeline, just select the step after which you need to insert your new step, and apply your transformation.