How to know where the indicator is used (in which dashboard)

[Lisa71]

How to know where the indicator is used (in which dashboard)? 

[Priyanka_786]

@Lisa71 :

• Navigate to Admin Console from the Performance Analytics and click on “Dashboards” under the “Explore and Manage” 
• In the "Dashboards" window, click on the top left dropdown, and switch from "Dashboard Groups" to "Dashboards".
• Type the name of the dashboard you want to explore and click on the "Indicators" tab.
• This will show you the list of all of the indicators being used for that dashboard. You can also export the results if you need to by right click on column header.

Hope it helps. Kindly mark helpful/accepted if it helps.

Regards,

Priyanka Salunke.

[AndersBGS · Accepted solution]

Hi @Lisa71 ,

You can create a simple database view to show which pa widgets is used on which dashboard - example below:

This will generate the result:

Note that above will only show the main indicator listed on the widget. If you also would like an alternative to another database view for the related indicators, then the database view should look as below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Lisa71]

This is great. Thank you! Could you show the detailed "where clause" as part is hidden in your screenshot. Thanks you. 

[AndersBGS]

Hi @Lisa71 ,

Sure, Also think that I will post an article about the solution. But basic, I have enhanced the solution a little.

Database view:

Where clauses:

prefrend:

p.sys_id = prefrend.portal_section && prefrend.name = 'renderer' && prefrend.value = 'com.glide.ui.portal.RenderReport' || p.sys_id = prefrend.portal_section && prefrend.name = 'renderer' && prefrend.value = 'com.snc.pa.ui.RenderPerformanceAnalytics'

Prefrep:

p.sys_id = prefrep.portal_section && prefrep.name = 'sys_id'

Repstat:

rep.sys_id = repstat.report_sys_id || wid.sys_id = repstat.widget_sys_id

The rest of the where clauses you can actually see in the screenshot. 

Based on above, you can create below Dashboard (Still work in progress):

Please also note:

• that "primary indicator" and "nested indicator" is named I have defined myself for the columns.
• Last run will provide timestamp for when either PA widget or report has last run
• Runs gives the count of how many times a widget or report has run

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders