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
You can use this step to set up a geographical hierarchy in your dataset. For example, to merge different cities into a single country, but still keep the cities level. This is useful in case you want to display a chart with a geographical drill-down.
This step is supported by the following backends:
- Pandas (python)
Where to find this step?
- Search bar
Hierarchy level column: The name of the column in which the hierarchy level should be stored.
Add hierarchy: Allows to add hierarchy levels. At least one hierarchy level must be added.