Unable to get Date Range Control to filter dates in Kibana Dashboard

[ChintanCParekh (Chintan Parekh)]

Hi Team,

I am working on visualization and dashboard in kibana. We have field called created_date with format datetime in an index pattern and so as in document. Hence we are trying to filter in visualization and dashboard using date range when it is embedded in application.

We are unable to find any ready to use date range control filter in kibana. We need a 'datetime picker control' for kibana dashboard or any other alternative which can be used to filter all the data in dashboard using date range.

Note :*** While designing date range filter option is available but while embedding control is required so that end user can work through date range and filter data accordingly.

Any help would be much appreciated.

[dosant (Anton Dosov)]

Hi @ChintanCParekh,

Does your index pattern has created_date as a time filter? If yes, then Kibana's date picker should use created_date for filtering.

Unfortunately, right now this date picker won't be visible in embedded mode. There is an issue to improve that: https://github.com/elastic/kibana/issues/9575 with significant progress.

As a temporary workaround, if you are embedding kibana in iframe, you could build you own date picker outside of kibana and control Kibana's time filter using URL. See example: https://github.com/elastic/kibana/issues/2739#issuecomment-97211862

Hope this is helpful!

[ChintanCParekh (Chintan Parekh)]

Hi dosant Anton Dosov,

Thank you for your kind help on the same.

We had already developed and tested the same where we have used visualization type : controls and place on dashboard using which we are able to filter all text or numeric data, but we have to show trend of data over period of say 3month, 6 months and 12 months for which we had given manual date control as you can see below.

Most important is end users need to slice and dice data w.r.t to date as well, which is not present as default control at least in kibana. Implementing it manually makes interfacce ugly to look and it is not that user friendly as well.

Eager to see these date filter visualization control as a fix in current version or in new version of kibana.

[dosant (Anton Dosov)]

@ChintanCParekh

Eager to see these date filter visualization control as a fix in current version or in new version of kibana.

FYI: https://github.com/elastic/kibana/pull/58435 - looks like this will allow to display Kibana's time filter in embed mode

Also not sure if you've tried Canvas as it has timefilter support inside the workpad.
It actually showcased in this tutorial: Canvas tutorial | Kibana Guide [7.7] | Elastic. (not suggesting to remake the dashboard using canvas, just sharing for future )