Hi Jerry, Thanks for the response. "It looks like you need to add your column Z to the BY clause of your COUNT function." - Unfortunately I tried this already where I tried to group by the relevant Column =1 but this only brought back ones and zeroes throughout, e.g. whereas I had 2-5's before where the majority of these…

Hi, The company is migrating to 12C next month If the feature is available in 12C then I can wait to make the improvements in the dashboard then! I am not involved in the setup of the database and behind the scenes, I'm more focused on creating reports in Answers.