3745884 - Canvas reporting shows purged user as anonymous instead of purged user

• In canvas (advanced reporting), data for a purged user displays as Anonymous instead of Purged user.
• In story reports, the same data displays as Purged user.

• Advanced Reporting (ODS)

1. Open a canvas report in Advanced Reporting (ODS).
2. Run a query that includes fields referencing a user who has been purged
3. Observe the output where the purged user’s values display as Anonymous instead of Purged user.

• By design in canvas (advanced reporting), when a referenced user is purged and not considered a valid user, the framework masks the display name and shows Anonymous rather than returning Purged user.

Note that this is expected behavior in canvas (advanced reporting); no product change is planned.
Implement a reporting workaround:
1. Edit the canvas/Advanced Reporting query.
2. Add a string calculated column (IF/CASE expression) that replaces values equal to “Anonymous” with “Purged user”.
3. Use the calculated column in place of the original name fields in the report output.

Alternatively, use Story reports for these fields, where purged users are already labeled as Purged user.

• refer to: Purged user is displayed as "Anonymous" in Employee Profile

canvas report, advanced reporting, ods, purged user, anonymous, masking, by design, story reports, canvas, reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem