Skip to content

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