updated dashboard queries