Time filter

Elastic Stack Kibana
1

I have a kibana graph made with vega that shows in a line graph some metrics over time and I want to be able to filter by time but the selector does not work for me.

2

Hi @tonichu ,

does your Vega spec contains the following arguments?

// Apply dashboard context filters when set
%context%: true
// Filter the time picker (upper right corner) with this field
%timefield%: @timestamp
3

noup

4

this is my grafh and i try with your request but does not work.
///
{
"$schema": ".../schema/vega-lite/v4.json",
"title": "Registros por zona en el tiempo",
%context%: true,
%timefield%: @timestamp,
"data": {
"name": "source",
"url": {
"index": "wifi",
"body": {
"size": 20,
"query": {
"match_all": {}
},
"_source": ["api_response.result.values"]
}
},
"format": {
"property": "hits.hits"
}
},
"params": [
{
"name": "interpolate",
"select": {"type": "point", "fields": ["metric"]},
"value":"bandwidth",
"bind": {"input": "select", "options": ["nodes", "connections", "bandwidth"]}
},{
"name": "grid",
"select": "interval",
"bind": "scales"
},
{
"name": "fechaInicio",
"value": "2000-04-15",
"bind": {"input": "date", "name": "Fecha de inicio"}
},
{
"name": "horaInicio",
"value": "00:00",
"bind": {"input": "time", "name": "Hora de inicio"}
},
{
"name": "fechaFin",
"value":"2024-04-15",
"bind": {"input": "date", "name": "Fecha de fin"},
},
{
"name": HoraFin",
"value":"00:10",
"bind": {"input": "time", "name": "Hora de fin"}
}

],
"transform": [
{
"flatten": ["_source.api_response.result.values"],
"as": ["flattened_values"]
},
{
calculate: toDate(datum.flattened_values[0])
as: timestamp
},
{
"calculate": "datum.flattened_values[1]",
as: "uid"
},
{
"calculate": "datum.flattened_values[4]",
as: "typemeter"
},
{
"calculate": "datum.flattened_values[5]",
as: "alias"
},
{
"calculate": "datum.flattened_values[6]",
as: "lat"
},
{
"calculate": "datum.flattened_values[7]",
as: "lon"
},
{
"calculate": "datum.flattened_values[8]",
as: "cota"
},
{
"calculate": "datum.flattened_values[9]",
as: "description"
},
{
"calculate": "datum.flattened_values[10]"
as: "description_origin",
}
{
"calculate": "datum.flattened_values[11]",
as: "name"
}
{
"calculate": "datum.flattened_values[12]",
as: "organizationid"
}
{
"calculate": "datum.flattened_values[13]",
"as": "origin"
},
{
"calculate": "datum.flattened_values[2]",
"as": "value"
},
{
"calculate": "datum.flattened_values[3]",
"as": "metric"
},
{
"timeUnit": "utcyearmonthdatehoursminutesseconds",
"field": "timestamp",
"as": "timestamp"
},

 {
 
   "filter": {
      "and": [{"param": "interpolate", "equals": "datum.metric"},

{"param": "fechaInicio", "equals": "timestamp"}
]

},
}

{
"joinaggregate": [

    {"op": "average", "field": "value", "as": "averageValue"}
  ],
  "groupby": ["timestamp", "origin"]
}

],
"mark": "line",
"encoding": {
"x": {
"field": "timestamp",
"timeUnit": "utcyearmonthdatehoursminutesseconds",
"title": "Timestamp",
"axis": { "labelAngle": 15 }
},
"y": {
"field": "averageValue",
"type": "quantitative",
"title": ""
},
"color": {
"field": "origin",
"type": "nominal",
"title": "Folder",

},"tooltip": [
{"field": "timestamp", "type": "temporal", "title": "Tiempo"},
  {"field": "uid", "type": "nominal", "title": "uid"},
   {"field": "metric", "type": "nominal", "title": "metric"},
       {"field": "typemeter", "type": "nominal", "title": "typemeter"},
           {"field": "alias", "type": "nominal", "title": "alias"},
               {"field": "lat", "type": "nominal", "title": "lat"},
                   {"field": "lon", "type": "nominal", "title": "lon"},
                       {"field": "cota", "type": "nominal", "title": "cota"},
                           {"field": "description", "type": "nominal", "title": "description"},
                               {"field": "name", "type": "nominal", "title": "name"},
                               
                                   {"field": "organizationid", "type": "nominal", "title": "organizationid"},
{"field": "origin", "type": "nominal", "title": "origin"},
{"field": "averageValue", "type": "quantitative", "title": "Valor Promedio"}

]
}
}
///