← Course Home
Okta Certified Workflows - Specialty · Part II

Create a Report

23% of Part II — the last use case, per the exam's own recommended order.

Create a Report

Task 2: Calculate Numbers of Users by User Type

3 tasks · this deck covers task 2 of 3

↑ Create a Report Overview

The Task

"Calculate numbers of users by us..."

The official study guide's task list truncates this line. Based on the use case name ("Create a Report") and the surrounding context, we're reading it as "by user type" — but that phrase is our inference, not a verbatim quote.

Honest Gap — Ambiguous Official Wording

Honest Gap Neither the List Functions reference nor the Numbers and Text page names a "count users by type" workflow directly — there's no single official tutorial titled anything like that. What follows is the general-purpose mechanism (List grouping/counting + Number totaling) that this task would require, built from real function documentation, not a fabricated Okta-specific walkthrough.

Step 1 — Group Users by Type

Given a list of user objects, the List function Group By will "extract a list, grouped by the values in the original list at the specified path" — pointed at a user-type field, this produces one sub-list per distinct user type.

Step 2 — Count Each Group

For each resulting sub-list, Length "finds the number of items in a list" — giving you the user count for that one type. Run through each group (e.g. with For Each, which "processes a list by calling a helper flow for each item") to get a count per user type.

Step 3 — Total the Numbers

The Numbers and Text page confirms Number functions cover "Add, Subtract, Multiply, and Divide" plus more advanced options like "Round, Remainder, and Factorial." Add sums the per-type counts back into a grand total for the report.

The Angle — What Trips People Up

Watch for this in your own sandbox run:

→ Grouping by the wrong path — Group By needs the exact field path in the user object where the type value lives, not just a loose label.

→ Confusing List's Length (item count) with a Number function — Length is a List function, not a Number function, even though its output is a number.

One Line To Remember

Group the user list by type with List's Group By, get each group's count with Length, then Add the per-type counts into a total with a Number function. The official task wording is truncated ("by us...") — we're reading it as "by user type" based on the use case name, and flagging that inference rather than guessing at specifics beyond it.

Sources: help.okta.com/wf — function-reference/functions.htm#list; learn/about-numbers-text.htm