Urgent Help: How to use date range in sub-aggregation in Kibana

Hi all,
I am trying to slice the data in Kibana using date range sub aggregation. It is giving me the required data in required format when I am putting just "now" for To but when I tried putting "now-1d" under To in order to get the data points between the time range of 14days ago and yesterday, it is giving me "-" in the last field which is the main field I want to work with.

Suprisingly everything I put under format is working until and unless the value for To is kept as "now" which I do not want because I want to slice the data. I am not sure where I am going wrong. I would really appreciate if someone could please help me with this.

For reference, I have attached the screenshot as well.

@Stratoula_Kalafateli can we please get some help on this please? I tried in my local and not sure what is really happening.

Thanks
Bhavya

@BIIntern1 can you please tell me which version of kibana you are using?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.