(Episode #93) A Step-By-Step Guide to Building Modern Dashboards

How to use custom property to filter out application status on these widget? Lets say I have custom property name as "server list" which includes further values like A,B,C. Each value(A,B,C) contains their own servers. Now I would like to create KPI widget which gives the status of application running on "A" with their name.  server name----Application running/template name----status(down/critical/warning etc)

Thanks! 
And, yes I am a firm believer in plagiarism.  o7

I'd pose this question in the Orion Platform forum.  My gut says, if you save it you should be able to display in in a Modern Dashboard as it's been saved.  That said, I haven't tested this one yet.

Is it possible when using Perfstack to save the "Display Transforms"? Reason: I need to show an API Poller result as "Difference".

KMSigma Very nice examples 

One thought to the use of the new API Pollers together with the new dashboards. I got the error that the value I used for my widget is 'nvarchar'?! After a while I figured out that the number was to big (8GB in byte) so I used the ABS() SWQL function  and some '/1024' divisors to come to an integer (from byte to megabyte). 

Here is the result it also changes the color when the free value below 80% maybe it helps others:

-- SWQL query for getting used and free Heap memory (in byte) for a propotional widget
-- Challenge: 
--   1. No Free but a "Total" value given
--   2. Values to big and stored as string but ABS() helps :)
-- Using a join to the same table to get total and used value for caclculationg free
-- Also set some colors depending on how much memory is used
-- Notice:
--   'Heap Memory Usage Max' is the total amount of heap memory for the JVM
--   'Heap Memory Usage' is the used memory
-- Both names set as 'Display Name' for the metric when the API poller was created
SELECT 
    -- Set Values
    CASE 
        -- turning value max into free value
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage Max' THEN ((ABS(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)-(ABS(AP2.RequestDetails.ValueToMonitors.Metric)/1024/1024)) 
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage' THEN (ABS(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)
    END AS Value,
    -- Set Names
    CASE 
        -- turning Name max into free Name
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage Max' THEN 'Free Heap Memory (MB)' 
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage' THEN 'Used Heap Memory (MB)'
    END AS Name,
    -- Set Colors
    CASE 
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage Max' THEN 
            -- Change 'Free' color from green to red if it is under 80%
                WHEN (((abs(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)-(abs(AP2.RequestDetails.ValueToMonitors.Metric)/1024/1024))/(abs(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)*100) < 20 THEN '#FCA01D'
                -- Setting to nice green color
                WHEN (((abs(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)-(abs(AP2.RequestDetails.ValueToMonitors.Metric)/1024/1024))/(abs(AP.RequestDetails.ValueToMonitors.Metric)/1024/1024)*100) > 20 THEN '#1caa23'
            END
        WHEN AP.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage' THEN '#0079AA'
    END AS Color
FROM Orion.APIPoller.ApiPoller AP
JOIN Orion.APIPoller.ApiPoller AP2 on AP2.ID=AP.ID
-- The Api Poller Name
WHERE AP.Name = '[Your API Poller Name]' 
-- First: Both values, Total and used (for me it's the values starting with  'Heap Memory Usage'
AND AP.RequestDetails.ValueToMonitors.DisplayName like 'Heap Memory Usage%'
-- Second: Only the value of used Memory
AND AP2.RequestDetails.ValueToMonitors.DisplayName = 'Heap Memory Usage'

 If you put that to a Donut you my get something like that: