Plan your transformations
Here are some common scenarios for popular transformations:
Add field from calculation - Use this for when you want to create a new field based on your existing data, such as calculating a total, difference, percentage, or ratio. For example, do you need to calculate CPU usage percentage or error rate for your application?
To learn about this transformation, go to milestone 3.
Group by - Use this when you need to aggregate data based on one or more fields, such as grouping by a specific category or region. For example, do you need to count errors per hour or find the total sales by product category?
To learn about this transformation, go to milestone 4.
Filter data by values - Use this when you need to filter out rows based on specific values. For example, do you want to display data that only meets certain thresholds, such as high CPU usage or system bugs that are only critical?
To learn about this transformation, go to milestone 5.
Join by field - Use this when you want to combine results from multiple queries or data sources that share a common field. For example, do you need to merge server metrics from multiple queries that share the same server name?
To learn about this transformation, go to milestone 6.
Organize fields by name - Use this when you want to reorder, rename, or hide columns to make your visualization clearer, especially after applying multiple transformations. For example, do you want to hide fields that are not relevant or modify the column names?
To learn about this transformation, go to milestone 7.