calculate aggregate status from redis directly