ah, I see. Yeah, not the best user experience as I'd like to only show the latest value in the table, not the latest / current value at the top.
I've managed to work around it by a brute force approach because as I evaluated my requirements, Kibana was just not going to allow me to display the information I needed in the format required.
For example I need a single table to display the current day Profit & Loss, the Month to Date P&L and Year to Date P&L. While all these pieces of information could be obtained by selecting the Kibana picker at "Today", "This Month" and "This Year", each of these time filters would aggregate the numbers based on the time range, it simply isn't possible to have all three numbers in a table. Further I needed this breakdown of current. MTD and YTD in a table with other groupings like by department.
The issue about kibana supporting separate time filters per visualization would not have helped with such a scenario without making the dashboard kludgy with three separate tables.
Presentation of such data (current, MTD and YTD) is pretty straightforward by traditional reporting or BI tools. I ended up adding MTD and YTD attributes on the document definition and maintain a running total of these numbers at the time of insertion / update into ElasticSearch. It's not the cleanest solution but it works and allows me to deliver on the requirements.