What does the computeExpression transformation allow you to do with datasets?

The computeExpression transformation is specifically designed to enhance datasets by allowing users to add derived fields using SAQL (Salesforce Analytics Query Language) expressions. This feature enables analytics practitioners to perform calculations and derive new metrics directly within their datasets, leveraging the power of SAQL to create expressions that can manipulate existing fields, apply mathematical functions, and formulate new data points relevant to their analysis.

This capability is crucial for creating insightful reports and dashboards, as it allows analysts to build more complex measures and dimensions that reflect business logic or analytical needs without altering the original dataset structure. By creating derived fields, users can gain deeper insights, filter and segment data effectively, and visualize results directly in their analytics applications.

The other options pertain to functionalities that are outside the scope of what computeExpression offers. For instance, combining rows from multiple datasets or extracting data from external sources involves different transformations or methods in CRM Analytics, while performing real-time data analysis typically refers to other techniques or tools that focus on processing data continuously rather than through derived field calculations.