Unable to create BAR chart dashboard

[Deepu]

Hello,

Iam not able to create ES bar chart with below configurations. can someone suggest anything I need to adjust in the query 

Dashboard Query

SELECT 
   ar.ENDPOINTASCSV AS 'label', 
    COUNT(DISTINCT ar.jbpmprocessinstanceid) AS 'data'
FROM 
    ARS_REQUESTS ar
GROUP BY 
    ar.ENDPOINTASCSV

LOCAL QUERY

SELECT 
   ar.ENDPOINTASCSV AS 'label', 
    COUNT(DISTINCT ar.jbpmprocessinstanceid) AS 'data'
FROM 
    ARS_REQUESTS ar
WHERE  ar.ENDPOINTASCSV=${endpointNum}

lOCAL fILER QUERY

{"parameters":[{"paramName":"endpointNum","parentParam":"","label":"Endpoint Name","type":"dropdown","dataType":"query","value":"SELECT DISPLAYNAME AS 'key', name as 'displayValue' FROM ENDPOINTS WHERE DISPLAYNAME  IN ('AutoSys','Canary', 'HANA', 'DBWorks', 'Hyperion Planning', 'Logility', 'Maintenance Connect', 'MITE','CRM/Dynamics','GainSeeker','Ignition','JDA Fulfilment','MII','Power BI')"}]}

[PremMahadikar · Accepted solution]

Hi @Deepu,

This is working for me. Try below:

Dashboard Query	SELECT ar.ENDPOINTASCSV AS 'label', COUNT(DISTINCT ar.jbpmprocessinstanceid) AS 'data' FROM ARS_REQUESTS ar GROUP BY ar.ENDPOINTASCSV
Chart Properties	{}
Local Query	SELECT ars.ENDPOINTASCSV as 'label', COUNT(DISTINCT ars.jbpmprocessinstanceid) AS 'data' FROM ARS_REQUESTS ars,endpoints ep where ars.ENDPOINTASCSV=ep.endpointname and ep.endpointkey=${endpointNum}
Local Filter Query	{"parameters":[{"paramName":"endpointNum","parentParam":"","label":"Endpoint Name","type":"dropdown","dataType":"query","value":"Select distinct at.endpoint as 'key',ep.endpointName as 'displayValue' from endpoints ep inner join arstasks at on ep.endpointkey=at.endpoint where ep.endpointkey is not null"}]}

Dashboard preview:

After Filter:

If you find the above response useful, Kindly Mark it as Accept As Solution and hit Kudos

[Deepu]

Its working. Thanks for the response