Data Aggregator Tool

<p><strong>Tool Description</strong></p><p><br>This tool performs <strong>flexible data aggregation</strong> on customer-related datasets.<br>It takes user-defined inputs (groupby columns, measure, and aggregation function) and produces aggregated customer data in JSON format for downstream use by an AI agent.</p><p>The <strong>Data Source</strong> parameter controls whether the aggregation is performed on the <strong>cached customer data</strong> (from a previous lookup) or on the <strong>full dataset</strong>. This enables more efficient workflows, where the agent can either focus on a single matched customer or compute aggregations across all available records.</p><p><strong>Input Parameters</strong></p><ul><li><p><strong>Groupby Columns</strong><br>A list of categorical columns used to define the grouping level for the aggregation.<br><em>Example:</em> ["Customer","Year"]</p></li><li><p><strong>Measure</strong><br>A numeric column to aggregate.<br><em>Example:</em> "Sales"</p></li><li><p><strong>Aggregation Function</strong><br>A function specifying the operation to apply to the measure.<br>Supported: <strong>Sum, Mean, Min, Max, Count, Median</strong></p></li><li><p><strong>Data Source</strong><br>Determines whether to use the <strong>cached customer data</strong> (subset of records) or the <strong>original dataset</strong> (all records).</p></li></ul>