Is there any way to make the table contents Colorful in modern dashboard table widget

Can we create table widget by providing color to the text or the rows with availability 100% as green 90% as yellow and 80% as red or any color

Query Used:
SELECT DeviceCountry as ImpactedSite, ROUND(AVG(rt.Availability),2) as Availability
FROM Orion.ResponseTime as rt, Orion.NodesCustomProperties as cp
where rt.NodeID = cp.NodeID
and MINUTEDIFF(rt.DateTime,GETDATE()) <=15
and cp.DeviceSiteCategory is not NULL

Group by DeviceCountry ORDER by Availability ASC

Find more posts tagged with

SWQL

Modern Dashboards

npm

Dashboards

Accepted answers

All comments

adam.beedell

You can add charts and icons for sure

I believe you can colour text but I dont think you can colour backgrounds. Might need to be fact-checked on that though

chad.every

Charts and Icons are the only coloring options that I know of. Inside of Modern Dashboards, row/column/cell formatting would be a feature enhancement I believe.

SteveK

Only thing close would be for Threshold Values, but those only have the precanned options.

You could probably hack around it a little bit with the icon approach. You would most likely need to do a case and return specific values for your tiers ( = 100, > 95, >90

NetDev_sol

@chad.every agreed possibly its a feature Enhancement

Even though using Case statements its not helping, for Icons as well same story.

SELECT
DeviceCountry AS Country,
ROUND(AVG(rt.Availability), 2) AS Availability,
CASE
WHEN ROUND(AVG(rt.Availability), 2) >= 99 THEN 'Green'
WHEN ROUND(AVG(rt.Availability), 2) >= 95 AND ROUND(AVG(rt.Availability), 2) < 99 THEN 'Yellow'
ELSE 'Red'
END AS Color
FROM
Orion.ResponseTime AS rt
JOIN
Orion.NodesCustomProperties AS cp ON rt.NodeID = cp.NodeID
WHERE
MINUTEDIFF(rt.DateTime, GETDATE()) <= 15
AND cp.DeviceSiteCategory IS NOT NULL
GROUP BY
DeviceCountry
ORDER BY
Availability ASC;</pre>Output I got was belowI believe SWQL doesn’t support applying colors or ordering directly in the query. 

Any alterations or propose any changes or thoughts?