Query transformations
Last updated
Last updated
Infobridge provides a wide range of transformations to pivot, aggregate, join, merge, and append queries. Let's dive in!
You can create a copy or take a backup of your query before applying transformations. You can either hover over the query name and select Duplicate from the context menu or you can click the Duplicate Query option from the Home ribbon.
Use the Pivot Table option to easily re-structure your dimensions and measures and select the aggregation for totals and subtotals.
You can pivot row and column dimensions by dragging them into the respective buckets. Let's look at how to convert the Region column dimension into a row dimension.
Drag the Region dimension from the Columns bucket to the Rows bucket to pivot the columns into rows.
When you enable totals and subtotals, you can also specify the type of aggregation to apply: sum/average/minimum/maximum.
In this query, we've applied summation for the Profit measure and average for the Sales measure.
You can convert text dimensions into measures and vice versa. Drag the dimension into the Values bucket to convert it into a measure.
Use the Concat option to aggregate strings from multiple rows into a single string, with a delimiter of your choice. For instance, you can concatenate all the accounts under a particular segment and analyze data at a higher granularity, without losing any information.
Individual accounts are rolled up at Account type level, providing a concise summary of the dataset. The aggregated rows can then be consumed in other destination visuals.
