Tables
"table": {
"timeSeries": "YYYY-MM; MMM YYYY; P1M",
"groupBy": "$user, project",
"takeLast": 18,
"firstCol": 260
},
"connect": [
{
..
"hTotal": [
"(at(ls, -1) - mean(ls)) / std(ls)", "Z-Score", "0.0"],
"vTotal": [
"mean(ls)", "Mean", "0.0"]
}
]}
Notes
at(ls, index)
allows lookup of specific location in the list with negative values counted from the end.
Syntax
-
table
- timeSeries: expression
- groupBy: metric or $user
- title
- firstCol: number in pixels
- conditionalBackground: [color]: match expression
-
connect
- ..standard fields..
- hTotal: tuple with expression, title and format
- vTotal: tuple with expression, title and format