Dashboard - How to get data from Dashboard query

[void0703]

Hi all ,

I have written a query which will display number of user with less than 5 account this query works will on the data analyzer and also provides the proper number of count but when I try to use same query in my Dashboard query is not working and displaying as undefined, any solution 

Query :

 SELECT COUNT(*) AS "TOTAL" FROM ( SELECT COUNT(UA.USERKEY) AS "NO OF ACCOUNTS" FROM USERS U,USER_ACCOUNTS UA,ACCOUNTS A,ENDPOINTS E WHERE U.STATUSKEY = 1 AND U.USERKEY = UA.USERKEY AND A.ACCOUNTKEY = UA.ACCOUNTKEY AND A.STATUS in (1,'Manually Provisioned') AND A.ENDPOINTKEY = E.ENDPOINTKEY GROUP BY U.USERNAME HAVING COUNT("NO OF ACCOUNTS") < 5) AS TEMP

Char properties :

[{"tileType":1,"displayName":"Demo","clickable":"yes","chartType":"icon-user small","objectName":"Demo","className":"dashboard-stat red","category":"","clickType":"analytics"}]


Regards,

[DixshantValecha]

Hi @void0703 

We are checking on this and we will update you on this. 

[DixshantValecha]

Hi @void0703,

Could you please provide us with more information regarding whether you are seeing any errors in the log files when executing the above query.