← All ivy-agents
IVYXSTUDIO · IVY AGENT
S

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.

  1. 01
    Read the Sales sheet
    ivy.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
    path from the agent's input
    set
    sheet Sales
    returns
    row_count
    Ivy Node
  2. 02
    Clean the rows
    ivy.node.table-clean

    Cleans rows for analysis: trims text, drops empty rows, turns number columns into numbers and date columns into ISO dates.

    takes
    rows from step 1
    set
    number_columns ["amount"]
    date_columns ["date"]
    returns
    dropped
    Ivy Node
  3. 03
    Total per month
    ivy.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
    rows from step 2
    set
    group_by ["date"]
    value amount
    op sum
    period month
    returns
    groups
    Ivy Node
  4. 04
    Draw the chart
    ivy.node.chart-image

    Draws a bar or line chart of two columns of rows and writes it as a PNG file.

    takes
    rows from step 3
    set
    path reports/sales.png
    x date
    y amount
    kind bar
    title Monthly Sales Totals
    width 800
    height 400
    returns
    chart
    Ivy Node
  5. 05
    Lay out the table
    ivy.node.markdown-table

    Formats rows as a Markdown table, with the columns in the order given or as they first appear.

    takes
    rows from step 3
    Ivy Node
  6. 06
    Write the report
    ivy.node.file-write

    Writes text to a file, creating its folder, and returns the absolute path and the number of bytes written.

    takes
    text from step 5, markdown
    set
    path reports/sales.md
    overwrite true
    returns
    path
    Ivy Node

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.

Writes files

Inputs

FieldTypeDescription
pathrequiredstringThe .xlsx workbook; its Sales sheet is read.

Outputs

FieldTypeDescription
groupsintegerHow many months the report covers.
droppedintegerRows removed because every cell was empty.
row_countintegerHow many rows the sheet had.
chartstringThe PNG chart written.
pathstringThe 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
    path data/sales.xlsx
    expects
    groups equals 3
    dropped equals 1
    chart matches sales\.png$
    path matches reports/sales\.md$
  • q4-workbook

    Another workbook with other numbers is read, not a remembered one.

    given
    path data/q4/q4-export.xlsx
    expects
    groups equals 3
    dropped equals 1
    path matches reports/sales\.md$