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.