You can probably use a template grid in combination with the EnumClass widget to set the correct color - https://appstore.home.mendix.com/link/app/2641/
I agree with Adrej's feedback regarding template grid and Enum widget as a good approach if you want to set a visual report/output. If you want to make something a bit more interactive so you can drill into it, be sure to attach a "on-click" microflow to the enum value, or get creative with microflow that returns a string that you display as a string that you attach a link or url redirect to a detail view so the user can drill into the underlying details that makeup that result. There are lots of approaches so be creative and use the platform to innovate!
thanks for the quick response