---
title: "Kiweely builds a prompted Workday report, then answers…"
description: "A 2½-minute film: Kiweely builds a Workday custom report with a month and organization prompt and four calculated fields, then answers from the tenant."
url: https://kiweely.com/blog/workday-report-built-and-tenant-answer
---

# Kiweely builds a prompted Workday report, then answers from the tenant

A plain request becomes a saved, prompted Workday custom report with four report-only calculated fields. Then a plain question about the tenant gets an answer from its own worker data, checked against the report.

-   By Kiweely
-   November 16
-   2 min read

HR partners want a list of everyone reaching a work anniversary in a month they choose, for an organization they choose. We gave Kiweely that request in plain words and filmed what it did in a Workday Development tenant with its own test data. The film opens on the finished report and an answer from the tenant, then shows the whole build, sped up.

### Watch the film

[Play the film](https://www.youtube.com/watch?v=YOxN_nT5dP0)

## The report

Monthly Work Anniversaries is an advanced custom report on Workers for HCM Reporting. The person running it picks a supervisory organization, and the organizations under it are included, and a month from 1 to 12. It lists active workers with their organization, manager, job profile, hire date, the anniversary date this year and the years they reach, biggest milestones first.

Four report-only calculated fields do the date work: Build Date for this year’s anniversary, Date Difference for the years reached, and Format Date with Convert Text to Number to turn the hire date into a month the prompt can match. Nothing tenant-wide was added.

Run for Customer Support Center and January, it returns 14 people across Canada, US East and US West: three reaching 11 years, ten reaching 6 and one reaching 2.

## The question

Then we asked Kiweely: which organization has the most January anniversaries, and who reaches the biggest milestone? It answered from the tenant’s worker data in 36 seconds. Two organizations tie with six each, and 22 people reach 11 years, everyone hired on 1 January 2015. It then ran the saved report for one of those organizations and got the same six people.

## What the run took

Claude Opus 5.5 at High effort, 39 minutes from the request to the saved, checked report. Kiweely shared the report with the HR Partner security group and ran it while acting as an HR partner. Whether an HR partner with narrower security sees only their own organizations was not tested: every HR partner in this tenant also has company-wide access.

## Watch Kiweely Vine build a report with date calculated fields

![Kiweely Vine's answer from the tenant beside the Monthly Work Anniversaries report it built in Workday](https://kiweely.com/blog/workday-report-built-and-tenant-answer/media/vine-report-and-tenant-answer-81abc3404a2f.webp)

From the film: the answer from the tenant beside the report.

From a plain request, Kiweely Vine builds a prompted Monthly Work Anniversaries custom report with four report-only calculated fields: Build Date, Date Difference, Format Date and Convert Text to Number. Then it answers a question from the tenant’s worker data and checks the answer against the report. 39 minutes from the request to the saved, checked report, in a Workday Development tenant.

[Watch the film (3 min)](https://www.youtube.com/watch?v=YOxN_nT5dP0) · [Start for free](https://kiweely.com/sign-in?intent=signup)

## Read next

[All posts](https://kiweely.com/blog)

-   [November 15 ### How to Review an AI-Built Calculated Field Chain Like a Senior HCM Lead](https://kiweely.com/blog/review-ai-built-calculated-field-like-senior-hcm)
-   [November 15 ### Approving Workday Expense Reports and Purchase Requisitions in Teams and Slack](https://kiweely.com/blog/workday-expense-report-and-requisition-approvals-in-teams-slack)
-   [November 13 ### Untangling a 14-Subreport Workday Composite Report Nobody on Your Team Built](https://kiweely.com/blog/reverse-engineering-inherited-workday-composite-reports)

### More guides on Reports and calculated fields

[All 25 guides](https://kiweely.com/guides#reporting)

-   [Slow Workday Custom Reports: Fixing Data Source Filter and Calculated Field Timeouts](https://kiweely.com/guides/workday-slow-custom-report-performance-tuning)
-   [Workday Calculated Fields: How to Build Them and Fix Common Errors](https://kiweely.com/guides/workday-calculated-fields)
-   [Workday composite reports: fix Map Fields For Join errors, prompt sets and subreport problems](https://kiweely.com/guides/workday-composite-report-errors)
-   [Workday calculated fields tutorial: every function type with a worked example, including extract single instance](https://kiweely.com/guides/workday-calculated-field-types-examples)
-   [Why a Workday user can’t see a field, report, or task](https://kiweely.com/guides/workday-user-cannot-see-field-task)
-   [Why a Workday report returns no rows, or the wrong rows](https://kiweely.com/guides/workday-report-no-rows)
-   [Why does my Workday calculated field return blank in a report?](https://kiweely.com/guides/calculated-field-returns-blank)
-   [Why a Workday calculated field is missing from the report field picker](https://kiweely.com/guides/why-workday-calculated-field-missing-from-picker)

## Your Workday work, done by AI.

Kiweely Vine is the AI agent that builds, deploys and tests Extend apps as real people, makes changes in any Workday task screen, answers from your real tenant and builds reports.

[Start for free](https://kiweely.com/download) [See how it works](https://kiweely.com/vine/how-it-works)

## Get the next one in your inbox.

One email a month for Workday teams: what’s changing in Workday and what to retest, one tip tried in a real tenant, and what’s new at Kiweely.
