Hi Shashank_87,
I am not 100% sure if this is what you are looking for but check this run anywhere example... might get you started
Its basically your search just adding the max value (of the hourly count) for that day next to the count per hour. I think this is what you are looking for.
index=_* sourcetype=splunkd_ui_access
uri="/en-US/app/search/ops_dc_status/_current"
| stats count as TotalHitsPerHour by date_hour, date_mday, uri
| eventstats max(TotalHitsPerHour) as maxDailyCt by date_mday, uri
| table date_hour, date_mday, uri, TotalHitsPerHour, maxDailyCt
Or try this example filled out for your usecase.
index=test sourcetype=access_combined requested_content="/*" NOT (images OR js OR css OR png OR gif OR json OR jpg OR woff OR eot OR ico OR ttf OR svg OR pdf OR php OR jpeg OR txt) status=200
| stats count as Totalcount by date_hour, date_mday, req_content
| eventstats maxTotalcount as PeakHourCount by date_mday, req_content
| table date_hour, date_mday, req_content, Totalcount, PeakHourCount
| sort - count limit=100
happy splunking!
=)
... View more