Dashboard Configuration Help

[Nathan]

When making a dashboard, I dont understand how to populate chart properties and global json query. The documentation has examples, but doesn't explain what the fields do (or at least i cannot find documentation that does). Any help is appreciated. Thanks

[rushikeshvartak]

• Chart properties are auto populated other than tile 

[Nathan]

When I enter a query like select count(*) C from users to make a dashboard showing current user count, and click save, i get a validation message saying chart properties cannot be empty. 

[rushikeshvartak]

What is type of dashboard!

[Nathan]

I tried all types. I dont see the behavior you are describing

[rushikeshvartak]

Share screenshot . https://forums.saviynt.com/t5/identity-governance/dashboard/m-p/123359#M83080

[Nathan]

can you explain the following table to me? The documentation doesnt really explain what any of it means or how to use it, so im not gaining too much value from the docs.

Dashboard Type Tile

Dashboard Query	select count(*) as 'totalCount' from entitlement_values ev inner join entitlement_types et on ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY inner join endpoints ep on et.ENDPOINTKEY = ep.ENDPOINTKEY inner join securitysystems ss on ep.SECURITYSYSTEMKEY = ss.SYSTEMKEY inner join externalconnection excon on ss.EXTERNALCONNECTION = excon.EXTERNALCONNECTIONKEY inner join externalconnectiontype conType on excon.EXTERNALCONNECTIONTYPE = conType.EXTERNALCONNECTIONTYPEKEY where conType.CONNECTIONTYPE = 'AWS' and et.ENTITLEMENTNAME = 'EC2Instance' and ev.STATUS = 1 and ev.customproperty1 not like '%terminated%'
Chart Properties	[{"tileType":1,"data":1595,"displayName":"EpNon-ESAnalytics","clickable":"yes","chartType":"icon-warning-sign","objectName":"EpNon-ESAnalytics","className":"dashboard-stat red-intense","clickType":"analytics"}]
Filter Type	Endpoint
Status	Active
Global JSON Query	{"query":"select count(*) as 'totalCount' from entitlement_values ev inner join entitlement_types et on ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY inner join endpoints ep on et.ENDPOINTKEY = ep.ENDPOINTKEY inner join securitysystems ss on ep.SECURITYSYSTEMKEY = ss.SYSTEMKEY inner join externalconnection excon on ss.EXTERNALCONNECTION = excon.EXTERNALCONNECTIONKEY inner join externalconnectiontype conType on excon.EXTERNALCONNECTIONTYPE = conType.EXTERNALCONNECTIONTYPEKEY where conType.CONNECTIONTYPE = 'AWS' and et.ENTITLEMENTNAME = 'EC2Instance' and ev.STATUS = 1 and ev.customproperty1 not like '%terminated%' and et.endpointkey in (${ENDPOINTKEY})"}

[rushikeshvartak]

• Dashboard Query - query should return with alias as totalCount
• Chart Properties - Chart colors logo name details
• Filter Type - filter on which type endpoint/orgnization
• Global JSON Query - On filter run query

[Nathan]

Probably should be a different thread, but how do I even use a dashboard. i Created on based on the sample from the docs. but how do I add it to the UI to see it

[rushikeshvartak]

If its new topic create new thread. You need to add dashboard under sav role

refer https://forums.saviynt.com/t5/identity-governance/dashboard/m-p/123359#M83080