Dashboards - how to get the data from Dashboard Query?

[yogesh]

I want to make a simple dashboard but the docs are such poorly written that I'm unable to figure that out.

Any ways here's what I have, I want to display a tile with the total user count:

But I get:

All the samples provided in the Docs are hardcoded, which is not very helpful as it just prints whatever is in the json:

Just like that in entire Doc the values are hardcoded, and even with such great wall of text I can not decipher how to get the simplest dashboard working.

[rushikeshvartak · Accepted solution]

SELECT COUNT(MITIGATINGCONTROLID) AS 'totalCount' FROM mitigatingcontrols;

[{"tileType":1,"data":2,"displayName":"Mitigating Controls","clickable":"no","chartType":"icon-warning-sign","objectName":"","className":"dashboard-stat orange-new","category":"","clickType":"category"}]

[yogesh]

Thanks Rushikesh,

I found out that there was an error in my query ("as" appears twice), so instead of throwing any errors Saviynt was just showing whatever I put into the "data": field. 

I tried after correcting the query and it seems that data field is updated automatically with the current value when you save the Dashboard. The docs never call out this behavior and combined with no error messages this became a real head scratcher for me.