Assessment by Project

This table displays the projects' assessments statuses.

Business Objects Assessments (data model class "assessment")
Values (or X-Axis and Y-Axis)
  • Columns: types of assessments (overall, finance, risk, schedule, and resource)
  • Rows: projects
  • Cells: assessment status for given project and assessment type
Sorting
  • Columns: fixed order (overall, finance, risk, schedule, resource)
  • Rows: by project name, alphabetically
Limits There is no limit.
Colors Colors are red, yellow, or green depending on assessment status.
Available Views Table view.
Interactions On this table, you can:
  • Click a row to refine on the corresponding project.
  • Click to access table menu and:
    • Search data
    • Swap axes
    • Export data
    • Configure visible and fixed columns
Technical Details
  • Data model
    • Class: assessment
      • Property: assess_status

  • Mashup feed (project)

    • Aggregations defined on related_project facet

      • overall: AVG(#has_category("Top/classproperties/assessment/assess_status/green", categories) * 0 + #has_category("Top/classproperties/assessment/assess_status/yellow", categories) * 1 + #has_category("Top/classproperties/assessment/assess_status/red", categories) * 2)
      • finance: AVG(#has_category("Top/classproperties/assessment/finance_status/green", categories) * 0 + #has_category("Top/classproperties/assessment/finance_status/yellow", categories) * 1 + #has_category("Top/classproperties/assessment/finance_status/red", categories) * 2)
      • risk: AVG(#has_category("Top/classproperties/assessment/risk_status/green", categories) * 0 + #has_category("Top/classproperties/assessment/risk_status/yellow", categories) * 1 + #has_category("Top/classproperties/assessment/risk_status/red", categories) * 2)
      • resource: AVG(#has_category("Top/classproperties/assessment/resource_status/green", categories) * 0 + #has_category("Top/classproperties/assessment/resource_status/yellow", categories) * 1 + #has_category("Top/classproperties/assessment/resource_status/red", categories) * 2)
      • schedule: AVG(#has_category("Top/classproperties/assessment/schedule_status/green", categories) * 0 + #has_category("Top/classproperties/assessment/schedule_status/yellow", categories) * 1 + #has_category("Top/classproperties/assessment/schedule_status/red", categories) * 2)