In a modern dashboard, we are looking for a way to make a KPI widget grid/matrix using a single SWQL query. Currently each individual KPI widget value requires a SWQL query or Entity outputting a single value. So, creating a dashboard of KPI widgets requires adding many individual single KPI widget values each with a separate SWQL query or Entity. If objects are added or removed from that data set, a new KPI widget needs to be created.
The bar chart (proportional) widget data-model functions this way, with a single SWQL query returning many rows, and Category and Value fields to build the relationship. Then the chart is generated.
If the KPI widget could look at a defined column name to understand what rows are the 'Group' items, then create a visual widget for every returned column as an 'Object', then the intersecting value would be displayed in the KPI.
We can sort-of create this idea using a table. But with a KPI widget grid, each cell would display a visual KPI instead, using a defined threshold or severity range to change color.
Think of the web service health status pages from AWS, Azure, Google etc. They use a "Products/Services" group list, then return all the values for the "Regions" objects.
