Sales Report
ivy.agent.sales-report · v1.1.0
ivyx
Reads a sales workbook, cleans it, totals the amounts per month, draws a bar chart and writes a Markdown report.
Steps
In the order the agent's file lists them, each with where its inputs come from and the values the file fixes. A branch or a loop is a step too.
- 01Ivy NodeRead the Sales sheetivy.node.excel-read
Reads one sheet of an Excel workbook into rows with the column names, row count and the workbook's sheet names.
- takes
pathfrom the agent's input- set
sheetSales- returns
row_count
- 02Ivy NodeClean the rowsivy.node.table-clean
Cleans rows for analysis: trims text, drops empty rows, turns number columns into numbers and date columns into ISO dates.
- takes
rowsfrom step 1- set
number_columns["amount"]date_columns["date"]- returns
dropped
- 03Ivy NodeTotal per monthivy.node.table-aggregate
Groups rows and sums, averages, counts or takes the minimum or maximum of one column, optionally by month, year or day of a date column.
- takes
rowsfrom step 2- set
group_by["date"]valueamountopsumperiodmonth- returns
groups
- 04Ivy NodeDraw the chartivy.node.chart-image
Draws a bar or line chart of two columns of rows and writes it as a PNG file.
- takes
rowsfrom step 3- set
pathreports/sales.pngxdateyamountkindbartitleMonthly Sales Totalswidth800height400- returns
chart
- 05Ivy NodeLay out the tableivy.node.markdown-table
Formats rows as a Markdown table, with the columns in the order given or as they first appear.
- takes
rowsfrom step 3
- 06Ivy NodeWrite the reportivy.node.file-write
Writes text to a file, creating its folder, and returns the absolute path and the number of bytes written.
- takes
textfrom step 5,markdown- set
pathreports/sales.mdoverwritetrue- returns
path
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 and what the agent's own file declares, such as moving a robot, 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 | The .xlsx workbook; its Sales sheet is read. |
Outputs
| Field | Type | Description |
|---|---|---|
| groups | integer | How many months the report covers. |
| dropped | integer | Rows removed because every cell was empty. |
| row_count | integer | How many rows the sheet had. |
| chart | string | The PNG chart written. |
| path | string | The Markdown report written. |
Tests
2 of 2 test cases passed on Oct 7, 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.
- given
pathdata/sales.xlsx- expects
groupsequals 3droppedequals 1chartmatches sales\.png$pathmatches reports/sales\.md$
- q4-workbook
Another workbook with other numbers is read, not a remembered one.
- given
pathdata/q4/q4-export.xlsx- expects
groupsequals 3droppedequals 1pathmatches reports/sales\.md$