DX Application Performance Management

Does any one try to query date using APMSQL using SQuirrelL.

I am running following query which is working fine

SELECT   agent_name ,   
        metric_path ,   
        metric_attribute ,   
        Avg ( agg_value )   CI   
FROM     numerical_metric_data   
WHERE    frequency   >=   15000   
        AND   metric_path   LIKE   'SAPAgent|Store|com.controllers.pages.PageController%'   
        AND   agent_name   =   'cdcscmap20_2017'   
        AND   ts   BETWEEN   {ts '2017-08-20 12:00:00.0'}   AND   
                       {ts '2017-08-23 12:00:00.0'}   
GROUP    BY   agent_name ,   
           metric_path ,   
           metric_attribute

but when I am trying query data from Custom Metric Agent I am not getting any results

SELECT   agent_name ,   
        metric_path ,   
        metric_attribute ,   
        Avg ( agg_value )   CI   
FROM     numerical_metric_data   
WHERE    frequency   >=   15000   
        AND   metric_path   LIKE   'ABCOrder Perfection Rate %'   
        AND   agent_name   =   'Custom Metric Agent (Virtual)'   
        AND   ts   BETWEEN   '2017-08-20 12:00:00.0'   AND   
                       '2017-08-23 12:00:00.0'   
GROUP    BY   agent_name ,   
           metric_path ,   
           metric_attribute

I also try to use  AND   metric_path   LIKE   'Business service Reliability|Perfection Rate|ABCOrder|ABCOrder Perfection Rate %'  

but didn't work

Converting to a Discussion since more of a how to