Visualisation based on filter

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

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