query changes for group dashboard