Viz
{
"mark": "interval",
"x": [
{
"kind": "dimension",
"ref": {
"dimension": "kicked_off"
},
"role": "continuous"
}
],
"y": [
{
"kind": "dimension",
"ref": {
"dimension": "category"
}
}
],
"color": {
"kind": "dimension",
"ref": {
"dimension": "phase"
}
},
"size": {
"kind": "metric",
"metric": "run_days"
},
"intervalUnit": "day",
"filters": [
{
"kind": "scalar",
"ref": {
"dimension": "kicked_off",
"transforms": [
{
"name": "inrange",
"args": [
"2023-01-01",
"2023-06-30"
]
}
]
}
}
]
}Query
{
"steps": [
{
"kind": "filter",
"filters": [
{
"kind": "scalar",
"ref": {
"dimension": "kicked_off",
"transforms": [
{
"name": "inrange",
"args": [
"2023-01-01",
"2023-06-30"
]
}
]
}
}
]
},
{
"kind": "select",
"metric": "run_days",
"transform": null,
"within": [],
"along": null,
"alias": null
}
],
"by": [
{
"ref": {
"dimension": "kicked_off",
"transforms": []
},
"alias": null
},
{
"ref": {
"dimension": "category",
"transforms": []
},
"alias": null
},
{
"ref": {
"dimension": "phase",
"transforms": []
},
"alias": null
}
],
"slice": [],
"order_by": [
{
"ref": "kicked_off",
"direction": "asc"
},
{
"ref": "category",
"direction": "asc"
},
{
"ref": "phase",
"direction": "asc"
}
],
"limit": null
}