Viz
{
"mark": "line",
"x": [
{
"kind": "dimension",
"ref": {
"dimension": "date",
"transforms": [
{
"name": "datetrunc",
"args": [
"month"
]
}
]
}
}
],
"y": [
{
"kind": "metric",
"metric": "revenue"
}
],
"filters": [
{
"kind": "scalar",
"ref": {
"dimension": "date",
"transforms": [
{
"name": "inrange",
"args": [
"2023-01-01",
"2023-01-31"
]
}
]
}
}
]
}Query
{
"steps": [
{
"kind": "filter",
"filters": [
{
"kind": "scalar",
"ref": {
"dimension": "date",
"transforms": [
{
"name": "inrange",
"args": [
"2023-01-01",
"2023-01-31"
]
}
]
}
}
]
},
{
"kind": "select",
"metric": "revenue",
"transform": null,
"within": [],
"along": null,
"alias": null
}
],
"by": [
{
"ref": {
"dimension": "date",
"transforms": [
{
"name": "datetrunc",
"args": [
"month"
]
}
]
},
"alias": null
}
],
"slice": [],
"order_by": [
{
"ref": "date__datetrunc_month",
"direction": "asc"
}
],
"limit": null
}