Platform Analytics Group By "Project Status" produces undefined as result. Pie Visualization

[rca1992]

I have upgraded the Dashboard/Reports to Platform Analytics and I am now receiving the "undefined" record count.  

I have create the data visualization from scratch with the same results.  

Any idea why its not recognizing the group by? 

Any help is appreciated.

Visualization Type: Pie

Data source: pm_project

Metric: Project Count

Group by: Project Status.

[Vikram Reddy]

Hey @rca1992,

This is a common one with pm_project: Project Status (Green/Yellow/Red) isn't a value you set directly on the project record, it rolls up from the Overall Health field on the most recently submitted Status Report (the project_status table). If a project has never had a status report submitted, that field is simply null on pm_project, and the Platform Analytics pie visualization doesn't bucket nulls into an "(empty)" group the way classic reports do, it renders them as literal "undefined". A pie that's 100% undefined across all 41 records almost always means none of those projects currently have a status report with Overall Health set.

• Open a handful of the 41 projects and check whether Project Status is actually blank on the form
• Check the Status Reports related list on those projects for any submitted records
• If a report exists, confirm Overall Health was selected and saved on it, since that is what feeds Project Status

Thank you,
Vikram Karety
Octigo Solutions INC