1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
export function getItems(data) {
let filteredData = data.filter((metric) => {
return metric.MetricValue !== 'nan';
});
let transform = filteredData.map((metric) => {
let date = new Date(metric.Timestamp);
return {
...metric,
Timestamp: {
time:
date.getHours() + ':' + String(date.getMinutes()).padStart(2, '0'),
date: formatDate(date),
},
MetricValue: Math.round(metric.MetricValue),
};
});
let group = transform.reduce(function (rv, x) {
(rv[x['MetricProperty']] = rv[x['MetricProperty']] || []).push(x);
return rv;
}, {});
return Object.keys(group).map((metric) => {
return {
name: metric,
current: group[metric][group[metric].length - 1].MetricValue,
middle: findAverage(group[metric]),
min: findMin(group[metric]),
minDate: findDateOfMin(group[metric]),
max: findMax(group[metric]),
maxDate: findDateOfMax(group[metric]),
};
});
}
function padTo2Digits(num) {
return num.toString().padStart(2, '0');
}
function formatDate(date) {
return [
padTo2Digits(date.getDate()),
padTo2Digits(date.getMonth() + 1),
date.getFullYear(),
].join('.');
}
function findAverage(arr) {
const { length } = arr;
return Math.round(
arr.reduce((acc, val) => {
return acc + val.MetricValue / length;
}, 0)
);
}
function findMin(arr) {
return arr.reduce(
(min, p) => (p.MetricValue < min ? p.MetricValue : min),
arr[0].MetricValue
);
}
function findMax(arr) {
return arr.reduce(
(max, p) => (p.MetricValue > max ? p.MetricValue : max),
arr[0].MetricValue
);
}
function findDateOfMin(arr) {
return arr.reduce((res, obj) =>
obj.MetricValue < res.MetricValue ? obj : res
).Timestamp;
}
function findDateOfMax(arr) {
return arr.reduce((res, obj) =>
obj.MetricValue > res.MetricValue ? obj : res
).Timestamp;
}
|
