Using the Data Tool

Everything you need to know about data, Scorecards, and KPIs in Ninety.

Written by Tommy Mains

Updated at September 5th, 2024

The Data Tool

The Data tool simplifies setting up and managing your team’s Scorecard to keep track of goals on five levels:

  1. Organization-wide
  2. Leadership Team
  3. Departmental
  4. Teams
  5. Individuals

Reviewing the Data tool every week is a critical function of team meetings. 

 

Primary Functions of the Data Tool

The primary functions of the Data tool include:

📖 Are you new to the Data Tool? Check out our introduction article here.

 

Operating Scorecards According to Your User Role

The functionality of the Data tool changes based on each user's role in Ninety. Click here for a basic understanding of user permissions for this tool.

 

Customizing Your Scorecards

To customize your team’s Scorecard

  1. Click Data from the left navigation.
  2. Choose your team from the dropdown.
  3. Click the gear icon on the right of the Filters bar.

 

Changing any of the Data tool settings affects all the team's Scorecards (Weekly, Trailing, Monthly, Quarterly, and Annual).

 

 

Hide Current Week

Hide the current week’s column from your team’s Scorecard by clicking the toggle to its active position.

A similar feature is available for the Monthly, Quarterly, and Annual Scorecard tabs.

 
 

Trailing Scorecard

With Trailing Scorecard enabled, you have an additional Scorecard tab in the Data tool: Trailing 4 & 13 Weeks.

Add pre-existing weekly KPIs to this tab to see real-time calculations of the Measurable over trailing 4 or 13-week periods. Each KPI's goal and scores are carried over directly from their weekly Scorecards. 

To add a pre-existing Measurable to your Trailing Scorecard:

  1. Click Data from the left navigation.
  2. Select a team from the dropdown.
  3. Click the Trailing Scorecard tab.
  4. Click the plus sign.
  5. Click Add an Existing KPI.
  6. Search for and then click the KPI you wish to add.
  7. Click Save.

To populate all your team’s non-smart Weekly KPIs to your Trailing Scorecard:

  1. Click Data from the left navigation.
  2. Select a team from the dropdown.
  3. Click the Trailing Scorecard tab.
  4. Click the plus sign.
  5. Click Add all Non-Smart KPIs from Weekly Scorecard.
  6. Click Save.

Displaying the Average or the Total

You can choose to display the average or the total for each KPI. 

To turn on or off the average or total column:

  1. Click the gear icon on the right of the Filters bar.
  2. Use the toggles to turn on or off a column.

If you have both columns on, you may want to disable one of the columns for a particular KPI. For example, any KPIs based on a percentage would only benefit from the average column, and some CSAT KPIs do not need the total column.

To turn on or off the average or total column on an individual KPI:

  1. Click on the KPI to open its details card.
  2. Click the toggle.
 
 

Measurable Total Column

Enabling the KPI Total column adds a column to all the team’s Scorecards to show the sum total of each KPI.

To change the number of reporting periods for the KPIs on a Scorecard, click the dropdown on the top right and choose your preferred option.

 
 

Measurable Average Column

Enabling the KPI Average column adds a column to all the team’s Scorecards to show the average score of each KPI.

To change the number of reporting periods for the KPIs on a Scorecard, click the dropdown on the top right and choose your preferred option.

 
 

KPI Status Color

When the KPI Status Color Indicator toggle in Data Settings is toggled on, a vertical, colored line appears on the far left of each KPI on the team’s Scorecard. The status color is based on each KPI's  goal — often called its target.

🟩 Green indicates the KPI has been on track for the previous three reporting intervals.
🟨 Yellow indicates the KPI was off track at least once over the previous three reporting intervals.
🟥 Red indicates the KPI was off track for the previous three reporting intervals.

 
 

Changing the Start Day

Choose the start day for Weekly KPIs that best fits your organization.

There are two ways to change your Scorecard’s start day, changing it in the Data tool or changing it organization-wide through company settings.

To change it in the Data tool:

  1. Click Data from the left navigation.
  2. Click the gear icon on the right of the Filters bar.
  3. Click the KPI Weekly Start Day dropdown.
  4. Click a weekday.

Or, to change it in your company’s settings — which changes the start day for the whole organization in Ninety:

  1. Click your name from the bottom of the left navigation.
  2. Click Company Settings.
  3. Click the KPI Weekly Start Day dropdown.
  4. Click a weekday.

 

Changing the start day for your Scorecard’s reporting period affects all historical Scorecards.

 
 
 

 

Organizing Your Scorecards

Organize your Scorecards by dragging and dropping KPIs into the order that most benefits your team. 

To drag and drop KPIs

  1. Click the Drag and Drop toggle on.
  2. Hover over the KPI you want to move.
  3. Click and hold the 12 dot icon on the far left of the KPI's row.
  4. While holding the click, move your cursor to drag the KPI up or down.

To add line breaks between groups of KPIs

  1. Ensure the Drag and Drop toggle is on.
  2. Hover over the bottom KPI of an identified group.
  3. Click the bolded line icon on the far left of the KPI's row.

 

Frequently Asked Questions (FAQs)

 

How do I add the trailing Scorecards?

To add a Trailing Scorecard for your team:

  1. Click Data from the left navigation.
  2. Choose your team from the dropdown.
  3. Click the gear icon on the right of the Filters bar.
  4. Click the Trailing Data toggle on.