Here you go..
index=_internal group="per_host_thruput" earliest=-3d@d latest=@d| streamstats max(date_mday) as D1 | eval D2 = D1-1 | eval D3 = D2-1 |stats sum(kb) by series D1 D2 D3
Output is
series D1 D2 D3 sum(kb)
cc-index01 28 27 26 78107.664978
cc-index02 28 27 26 78186.546889
cc-index03 28 27 26 78157.350569
cc-index04 28 27 26 78496.797853
cc-licmgr 28 27 26 52702.763749
cc-sh1a 28 27 26 45635.153433
cc-sh2a 28 27 26 44189.015641
cc-sh3a 28 27 26 44197.826188
you can use streamstats or eventstats commands to take the max value of given parameter.
if you want total, avg, max & min of volume injection by each host on daily basis, then use the below query
index=_internal group="per_host_thruput" | bucket _time span=1d |eval MB=kb/1024 |eventstats sum(MB) as daily_volMB by series | timechart span=1d sum(daily_volMB) as daily_volMB , max(daily_volMB) as max_daily_volMB avg(daily_volMB) as avg_daily_volMB, min(daily_volMB) as min_daily_volMB by series
As you have 200 hosts and you seems to be looking for each hostname to be in row
index=_internal group="per_host_thruput" | bucket _time span=1d |eval MB=kb/1024 |eventstats sum(MB) as daily_volMB by series | stats sum(daily_volMB) as daily_volMB , max(daily_volMB) as max_daily_volMB avg(daily_volMB) as avg_daily_volMB, min(daily_volMB) as min_daily_volMB by series _time
series _time daily_volMB max_daily_volMB avg_daily_volMB min_daily_volMB
myhost 2015-01-05 00:00:00 808.219299412 28.864974979 28.864975 28.864974979
myhost 2015-01-11 00:00:00 16712.820512841 28.864974979 28.864975 28.864974979
myhost 2015-01-29 00:00:00 1703.033523761 28.864974979 28.864975 28.864974979
... View more