Transform your data within Infobridge - add dimensions and measures, pivot columns, sort, filter, and format your data. Perform all these operations without modifying your source visual.
Let's explore the transformations available in Infobridge.
| TRANSFORMATION | DESCRIPTION |
|---|---|
| Pivot table | Restructure your dimensions and measures to align with the target report. |
| Group by | Summarize and aggregate your detailed data for crisp high-level reports. |
| Add column | Add calculated measures and custom dimensions. |
| Pivot column | Convert row values from one column into multiple columns. |
| Unnest | Flatten your comma-separated data into multiple rows. |
| Rename column | Change the name of any dimension or measure. |
| Find and replace | Search for a string or value and replace it with another. |
| Remove measure | Remove selected measures from the query. |
| Filter rows | Remove redundant rows that do not match the specified filter condition. |
| Sort | Apply a custom sort order for measures and dimensions. |
| Text functions | Extract and format text data. |
| Unnest | Convert delimited values into separate rows and flatten your data. |
| Round | Round numeric data to a specified number of decimal places. |
| Extract Comments | Extract cell-level comments from the source report into a separate column. |
| Import and export | Export and download transformation steps and import them into another query to re-apply the same steps. |
