Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/23/2024 02:20 PM
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')"}]}
Solved! Go to Solution.
04/23/2024 03:17 PM - edited 04/23/2024 03:18 PM
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
04/25/2024 07:13 AM
Its working. Thanks for the response