How To: Add a New Metric

This guide illustrates how to use the Metric Configuration Tool available as part of the Ed-Fi Dashboards code base to add new metrics to the metric metadata. The exercise walks through adding a new High School Transportation metric as an example. This is a precursor step to writing metric calculation code (which is covered in detail in the ETL Developers' Guide - Coding section).

Step-by-Step Guide

It is recommended that the latest Dashboard Types CSV files get imported before editing. The metric configuration tool assumes the file versioning is managed via source control and checked in after every edit. 

A high-level overview of the steps is as follows:

Each step is described in detail, below.

Step 1. Import the Existing Dashboard Type CSV Files

Start by importing (i.e., uploading) the existing Dashboard Type CSV files.

• Click Choose Files.
  
• Navigate to the Dashboard Type CSV files. By default, the files can be found under /Ed-Fi-Dashboard/Etl/src/EdFi.Runtime/Reading/Queries/{ODS version}/DashboardTypes.
  
• Click Upload. Progress messages are shown on-screen.
  

Step 2. Add a New Transportation Category for the Metric

• Go to Edit Metric Navigation, click Edit.
  
• Navigate to the School Hierarchy Node.
  

• Click Add Category.
  
• The Id value will be automatically assigned to the next available number. The other values for this walkthrough are:
  • Name: Transportation
  • Description: Sample transportation summary metric
  • School Categories: High School
  • Enabled: Yes
• When you've entered the values, click Create.
  
  

Step 3. Add a New Aggregate Metric to the Transportation Category

• Click on the new Transportation Category
  
  

• Add a new Aggregate Metric by clicking the Add New button. 
• Select As a Child and click Next.
  
• Select High School Category and click Next.
  
• The Basic Information for this walkthrough is:
  • Id: 2174
  • Name: Transportation Method Rate
  • Metric Type: Container
  • Enabled: Yes
  
• Click Create.

Step 4. Add a New Granular Metric

Now we'll add a new granular metric as a child of the Transportation Method Rate we just created.

• Click on the newly created Transportation Method Rate.
  
• Click Add New Metric.
• Set Metric Level - As a child.
• Select Categories - High School.
• The Basic Information for this walkthrough is:
  • Id: 2175
  • Name: To and From School Transportation Method
  • Type: GranularMetric
  • Enabled: Yes
  
• Click Create.

At this point, you should have a new "To and From School Transportation Method" metric. You'll see a screen that looks something like this:

Step 5. Export the Updated CSV Files

Exporting the updated files is easy:

• Go back to the Home page. 
• Click Export.
  
  

Step 6. Replace the Dashboard Types Files

• Replace the Dashboard Types files under theEd-Fi-Dashboard/Etl/src/EdFi.Runtime/Reading/Queries/{ODS version}/DashboardTypes/.