Archibus Metric Trend Values table (afm_metric_trend_values)

The metrics rule stores metric values for tracking metrics into the afm_metric_trend_values table. Archibus Admins may wish to access to this table if they are:

• Importing tracking metric values from an exterior source, such as a finance database
• Writing a workflow rule to calculate tracking metric values
• Querying metric trend values for their own reports or charts

Note: From the Metric Trend Values view you work with only tracking metrics. To work with analysis metrics, see User Help topic: Real Estate Portfolio Management / Strategic Financial Analysis / Personalize SFA from Smart Client / Define Analysis Metrics .

For each metric and recurrence time period, the table holds:

• One record for each "all" or portfolio-wide granularity
• One record for each distinct value of each drill-down granularity. For instance, if you have a "by Department" granularity, and you have 50 departments, you will have 50 records for each time period for the metric.

Access this table at: System / Add-In Manager / Metrics Trend Values .

Note that the view includes Export and Filter buttons so that you can filter the list and export the trending metrics to embed in presentations and reports. To avoid performance issues, the export is set to maximum of 1000 records per file. Typically you will want first to filter values for their targeted metric, granularity, and date and not export the entire table.

Field Title	Field Name	Description
AutoNumbered ID	auto_number	The primary identifier of the record. This is an autonumbered value. If you import data, leave this column blank to have the database assign your values new unique identifiers.
Metric name	metric_name	The metric to which this data belongs.
Collect Group By	collect_group_by	The granularity type by which a metric is collected, e.g. "dv_id;dp_id". The metric rule uses the assignments in the ‘afm_metric_grans’ table to obtain this value for the record.
Collect By Value	collect_by_value	The value of the granularity for which the metric is collected. For instance, if your Collect Group By is ""dv_id;dp_id" for "by Department" the Collect By Value will be of the form "ACCESSORIES;SALES".
Date Collected	metric_date	The calendar date on which the metrics rule collected this set of data, e.g. "2015-02-01". Typically, this is the first or last day of the week, month, quarter, or year.
Metric Value	metric_value	The numeric value collected for the metric, e.g. "1111.22"
Metric Value - Last	metric_value_last	The value collected for that metric in the last recurrence period (last week, month, quarter or year, for the same "Collected By Value" category). This value is an annotation that saves the previous value of the metric. This pre-annotation lets the home pages display summary metrics quickly, without self-joins or sub-queries. The data source into the Metric Value table provides calculated fields for absolute change, percent increase, etc.
Metric Value - Last Year	metric_value_last_yr	The value collected for this metric last year (i.e. 52 periods ago for weekly metrics, 12 periods ago for monthly, 4 periods ago for quarterly, 1 period ago for yearly).
Metric Values - Previous	metric_values_prev	A semi-colon-delimited array of the current value of the metric along with its other previous 19 values (if present), e.g. "11111.22;333333.44;55555.66"
Collect: Error Message	collect_err_msg	The error message resulted when the collection workflow rule, fails to collect the value for that metric (ex. in case of division by zero). Has the value "example" for each sample data record.

For values displayed in metric charts, the system uses "G" for "giga" e.g. $55.6G, instead of "B" for billions.