SQA Non-Conformance Dashboard

The SQA Non-Conformance Dashboard is intended to provide Builders with up-to-date information on the progress of inspections for work they performed on behalf of NYSERDA. Builders will only see data related to projects they are assigned through the dashboard and underlying reports. The dashboard and associated reports are static and cannot be changed or updated by Builders.

Accessing the Dashboard

Access the NYSERDA Salesforce Partner Portal

Once logged in, from the home screen, access the Dashboards tab.

If the SQA Non-Conformance Dashboard is not immediately visible, use the Find a dashboard drop-down to locate the SQA Non-Conformance Dashboard.

Dashboard Overview

Chart NameDescriptionChart Notes
1Deficiency by Defect CategoryDisplays, numerically and by percentage, the total number of deficiencies found during inspections on work you performed for the past 90 days and grouped by defect category
  • Moving your cursor over any data element on any chart opens a small tooltip with details of that data element.
  • Clicking any data element on any chart will bring you to the report Salesforce uses to generate that chart.
2Count of DeficienciesShows the total number of each deficiency type found during inspections on work you performed for the past 90 days with reference to the defect category for each deficiency.
3Deficiencies by FrequencyDisplays a list of all deficiencies and their respective count total, from highest to lowest, found during inspections on work you performed for the past 90 days.
Filtering & Exporting Report Data

Access the underlying chart data by clicking on any chart area. By default, report data is for the last 90 days.

Once on the report page, change the date range as required, being sure to click the Run Report button to re-generate the report using your chosen date range. You do not need to click the Run Report button if you are not changing the default date range of the last 90 days.

When you are ready to export the date, click the Export Details button.

On the next screen, select the correct Export File Format for your needs. The most common format is Excel Format .xls. Then, click Export.

Downloaded reports contain the following information:

ColumnColumn NameData Displayed
AProject Inspection: Project: ApplicationThe application number of the inspection project
BProject Inspection: Report Issued DateThe date the project was marked as complete in Salesforce
CProject Inspection: Project: Project NameThe name of the project record in Salesforce
DDisplay LabelThe specific deficiency uncovered during the inspection
EDefect CategoryThe deficiency category (Incidental, Minor, Major, Critical)

Follow the prompts to Name and Save the exported report to your computer or device.

Exported Report Filters & Sorting

The following guidance only applies if you have downloaded the report in Excel Format .xls and opened the file in either Excel (Mac or PC) or Numbers (Mac). Downloaded reports are static and will not change as the underlying data changes. To get the most recent data, re-access and export the report data.

Once you have the report open, you may want to first expand the size of each column so the data in each column does not appear to overlap one another. This can be done either by dragging each column header the needed size or double clicking the separator line between each column header. Double-clicking the separator line will auto size the column to the largest line of text in any cell in that column so the test is not cut off.

Additionally, to make the table easier to read, it may be helpful to also Format as Table. This adds some visual elements to the table to make the data easier to distinguish. When formatting as a table, be sure to select all columns and rows that contain data. First, select cell A1, then, select the cell in the last column and row using the shift key when clicking.

Sorting displays the data in different sequences, such as highest to lowest.

Filtering helps only show data that is significant for your specific needs.

  • No labels