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