The following SPL returns data for all returns for a day. How can I just return the maximum return for the day? Example: July 1 data returns 12 apples, 10 oranges, and 5 cherries I would only like to see 12 apples since its the highest count for that particular day. July 2 returns 10 grapes, 7 kiwis, and 3 dates, only returns 10 grapes for that day index=RazorApp sourcetype = TotalFruitsSold| | table CurrentDate, FruitsSold Any help would be greatly appreciated! ... View more