I have a dashboard component based on a report in which Opportunities are Grouped By CreatedDate with sum of revenue for every day.
The output is something like below. (Each color represents each day and the revenue values).
What I want is ONLY the highest/greatest amount among these values (3.5k) to be displayed. OR I want to know on which Date is the highest amount and display only that date. How can I get this done in a report/dashboard?
I don't mind changing the funnel to a metric or any other dashboard type and also willing to use 2 different reports/dashboard components etc.
Note: This is in Lightning Experience.