| foreach * [ eval <<FIELD>> = round(<<FIELD>>,0)]
| foreach * [ eval <<FIELD>> = round(<<FIELD>>,0)]
| chart eval(floor(count(channel)/7)) AS field_div_by_7 by channel time_hour
or
| chart eval(round(count(channel)/7, 0)) AS field_div_by_7 by channel time_hour
Sorry, bracket was in the wrong place - still not sure if it will work though
Neither way worked..