Kibana formula "reducedTimeRange" not working

[SamehSaeed]

I'm facing an issue while creating a visualization, whenever i use "reducedTimeRange" the result value becomes 0.

[SamehSaeed]

Found the solution, If you set date range to "Today" it will set the time from "00:00:00" to "23:59:59".
Using -5m reduced time range on the end of day will be "23:54:59" which does not have data yet, and that's why it will be empty. You just have to edit the "Today" statement from :
Stack Management ==> Advanced Settings ==> Time filter quick ranges

Change

{
    "from": "now/d",
    "to": "now/d",
    "display": "Today"
  }

To

{
    "from": "now/d",
    "to": "now",
    "display": "Today"
  }

So next time when you set date range to "Today" it will set the time from "00:00:00" to "Now" instead, and the reduced time range will always work if you are working with real time data.

[ersalil (Salil Agrawal)]

Try using unique_count(seqid, shift='30m')

[SamehSaeed]

@ersalil "shift" feature changes both start and end dates, and if you try to apply it in a data table an error will pop up

Thanks for your comment though .