Sales Report
ivy.agent.sales-report · v1.0.0
ivyx
Read sales data, clean it, aggregate monthly totals, generate a chart and a markdown report.
Steps
In the order the agent's file lists them. A branch or a loop is a step too; the wiring between steps is in the file.
- 01Ivy NodeExcel Readivy.node.excel-read
- 02Ivy NodeTable Cleanivy.node.table-clean
- 03Ivy NodeTable Aggregateivy.node.table-aggregate
- 04Ivy NodeChart Imageivy.node.chart-image
- 05Ivy NodeMarkdown Tableivy.node.markdown-table
- 06Ivy NodeFile Writeivy.node.file-write
Nodes it brings
Adding this agent in IVYX Studio adds these nodes with it. A node your workspace already has is kept as it is, even at another version.
What it touches
Collected from what each of its nodes declares, plus the model call when a step is a model turn. A declaration is the author's statement, and it is what policy rules select on.
Inputs
| Field | Type | Description |
|---|---|---|
| pathrequired | string | Path to the .xlsx file. |
Outputs
| Field | Type | Description |
|---|---|---|
| columns | array | Column names. |
| row_count | integer | How many rows were read. |
| sheets | array | Every sheet name in the workbook. |
| dropped | integer | Rows removed because every cell was empty. |
| problems | array | Values that could not be converted, as {row, column, value}; the cell is set to null. |
| groups | integer | How many groups there are. |
| value_column | string | The name of the aggregate's column: the value column's own name, or count. |
| path | string | The absolute path of the PNG written. |
| size_bytes | integer | The file's size. |
| x | string | The column drawn on the x axis. |
| y | string | The column drawn on the y axis. |
| bytes | integer | How many bytes were written. |
Tests
2 of 2 test cases passed on Oct 1, 2026, in the publisher's own environment, before this version was published. The registry keeps that record; it does not run the cases again.
Requires: python:3.9
- q3-workbook
The Q3 export: three months, the blank row dropped, a chart and a report written.
- q4-workbook
Another workbook with other numbers is read, not a remembered one.