Hi
I have a question regarding visualisations when selecting the maximum value from a field. Let me explain
I have an index where i have a document with the structure {timestamp, data}, so it can be like
{timestamp: 2019-01-27, car: ferrari}
{timestamp: 2019-01-27, car: ferrari}
{timestamp: 2019-01-27, car: ford}
{timestamp: 2019-01-26, car: ferrari}
{timestamp: 2019-01-26, car: ferrari}
{timestamp: 2019-01-26, car: ferrari}
What i want to visualise is the number of cars in a table for the maximum timestamps, so it should visualise
Ferrari 2
Ford 1
If i create as metric max timestamp, it displays the value of the maximum timestamp correctly, but then, i am not able to do a count of cars on that bucket
Any idea on how can i do this?
Thanks