Platform Analytics breakdown on custom Choice field returns "No data available"

adunay
Tera Contributor

I'm running into an issue with Platform Analytics (Automated Breakdowns) and I'm hoping someone can point out what I'm missing.

 

I have a custom Choice field on the Problem table:

  • Field: u_response_type
  • Values:
    • Predictive
    • Proactive
    • Reactive

I want to create generic Problem indicators (Problems Created, Problems Resolved, Open Problems, etc.) and use an automated breakdown by Response Type rather than creating separate indicators for Proactive and Reactive.

Indicator Source

  • Facts table: problem

Indicator

  • Daily count of resolved Problems
  • Collect Breakdown Matrix = true

Breakdown

  • Automated
  • Breakdown Mapping:
    • Facts table = problem
    • Field = u_response_type

Breakdown Source

  • Uses sys_choice (same pattern as the OOB Priority breakdown)
  • Filters:
    • Table = problem
    • Element = u_response_type
    • Language = en

If I group the exact same indicator by the OOB Priority breakdown, the visualization displays correctly.

 

If I group by the custom Response Type breakdown, the visualization returns:

"No data available"

Troubleshooting already performed

  • Verified the Problem records being collected have u_response_type populated.
  • Verified the indicator collects data successfully.
  • Enabled Collect Breakdown Matrix on the indicator.
  • Re-ran historical collection.
  • Compared the custom breakdown configuration against the OOB Priority breakdown—they appear functionally identical except for the field.
  • Ran Run Diagnostics on the breakdown with no reported errors.

Is there something obvious that I've missed?  Is there an additional configuration step required for custom Choice fields, or is there a known limitation with automated breakdowns on custom fields that doesn't affect OOB fields?

0 REPLIES 0