Data Trending - Sub-Totals and Metrics

[KLEITH21]

I am in need of a little direction on whether there is a boxed tool for my metrics or I should just create custom expressions/formulas.

I collect monthly kW readings (snap shot of schema below). The following metrics I need to report on are as follows:

1. Running Load Change AVERAGE (6 months) = kW
2. Overall Load Demand Differential (abs. value of 6 months) = % 
   1. Load Demand Trend (2% of Load Limit) = "Increasing, Decreasing, Static"

[CathyS_Slalom · Accepted solution]

Hi @KLEITH21, you would need to use the formula tool to create custom formulas to calculate the metrics that you want.

For example, (([22-Feb] - [22-Jan]) + ([22-Jan] - [21-Dec]) + ..... )/x (x is the number of month)