Kind of stuck on this one so any help would be greatly appreciated.
Lets say my data looks like this:
where monitoring table is any type of fruit, and every minute there is a record with the value.
What i'm currently trying to do is create a data table that shows for a specified duration (chosen from the time picker), what the max value was for each fruit for that time period.
I've used a filter bucket to filter out the monitoringtable (didn't use field because banana has an unreadable code of the sorts BA-N1-AA) and managed to get the max value, but i can't get the table to show a timestamp for when the max value occurred.
Filter - Max Value - Time Occured
banana - 1000 - Jan-03-2018
is it possible to display such information?
Thanks a lot