We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Can we redirect from bar charts to analytic report

rahul_p
Regular Contributor II
Regular Contributor II

Dear Experts,

Greetings!!!

We are configuring dashboard where we have requirement to redirect to filtered analytic report from dashboard.

For tiles its working, we have bar charts, so is it possible to redirect from bar chart? If yes, then can anybody give any pointer where can get some information about how to perform it.

Thank you in advance.

Cheers,

Rahul

15 REPLIES 15

rushikeshvartak
All-Star
All-Star

All dashboard’s can be made clickable

https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter18-Dashboards/Dashboards.htm


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

rahul_p
Regular Contributor II
Regular Contributor II

Thank you for your response @rushikeshvartak 

I went through this document, but its giving redirection option for tiles only, not for others like bar chart. How to specify the clickable option and redirection to specific analytic report for bar chart?

Regards,

Rahul

rahul_p
Regular Contributor II
Regular Contributor II

can anybody comment on this please?

Manu269
All-Star
All-Star

We even had the same ask.

As per my understanding redirection is possible only with tiles and not barchart.

@uthra_rahul Can we please get this validated?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

saparja
Saviynt Employee
Saviynt Employee

Hi @Manu269 and @rahul_p 

Redirection to analytics control details are supported for both tiles and charts. The way to configure the redirection depends on whether the dashboard type for tile/chart is set to ES tile/chart or not.

  1. For ES tiles, the redirection is based on "clicktype":"analytics" property in chart properties
  2. For ES charts, the redirection is based on the, linked analyticskey in the dashboard query section
  3. For non-ES charts, the redirection is based on the linked analytics from Dashboard Details > Analytics > Add New Analytics. For every label in the chart, we will have to link separate analytics controls

Regards,
Saparja

rahul_p
Regular Contributor II
Regular Contributor II

Hi @saparja ,

Thank you for your valuable response.

Point number 1 => we did implement and its working as expected for tiles.

For Point number 2 => what key values need to specify in query section? like in case of tiles, we use analyticsConfig and fieldToGroup key value pair, so what key values we need to specify in case of bar charts?

For point number 3 => when we are going to add analytics option, its not showing out control or analytic in add analytics option, we did create runtime analytic only but still its not showing under add analytic option.

Please comment.

Regards,

Rahul

saparja
Saviynt Employee
Saviynt Employee

For point number 2 => here is a sample dashboard query

{"analyticsConfig":"21","fieldToGroup":"Certifier Action","filterMap":{"Certifier Action":["No Response","Works for Me","Does not work for me","Terminated"]}}

For point number 3 => Since these associations are for non-ES dashboards, so only non-ES analytics controls are listed here.

Regards,
Saparja

rahul_p
Regular Contributor II
Regular Contributor II

Hello @saparja ,

Thank you for your response.

By referring to your example we are using below for Jobs with their state :

{"analyticsConfig":"1014","fieldToGroup":"JOB_NAME","filterMap":{"TRIGGER_STATE":["BLOCKED","WAITING","ACQUIRED","COMPLETE"]}}

Its not working.

Still we are not getting that which key we have to specify data column and which key we have label column need to specify?

Also where to specify the color? As in our query only we specified green as color to make all bars in green.

 

Please comment.

Regards,

Rahul

saparja
Saviynt Employee
Saviynt Employee

@rahul_p 

Point 2 in my response is for ES charts and for ES charts

  • colors are not configurable
  • it is not required to mention label and data columns (label and data is for non-ES charts only)

Also looking at 
{"analyticsConfig":"1014","fieldToGroup":"JOB_NAME","filterMap":{"TRIGGER_STATE":["BLOCKED","WAITING","ACQUIRED","COMPLETE"]}}
it seems that in filterMap you are putting various job status but in fieldToGroup, the job names are provided. Please provide the same field names in both the properties.

Please refer to sample dashboard queries based on dashboard types provided in https://docs.saviyntcloud.com/bundle/EIC-Admin-v2020x/page/Content/Chapter19-Dashboards/Dashboards.h... > Dashboard Details for Creating Charts 

Regards,
Saparja

rahul_p
Regular Contributor II
Regular Contributor II

Hello @saparja ,

Thank you so much for your confirmation.

One last thing related to non-ES charts, when we are going to add analytics option then its showing only runtime query. Is it expected behaviour? Also while adding, section label will contain label I guess but other 2-3 values what we have to enter? It would be great if you share any document reference for non-ES bar charts redirection.

Regards,

Rahul

rahul_p
Regular Contributor II
Regular Contributor II

Hello @saparja ,

Hope you are doing great.

Thank you so much for your confirmation.

One last thing related to non-ES charts, when we are going to add analytics option then its showing only runtime query. Is it expected behaviour? Also while adding, section label will contain label I guess but other 2-3 values what we have to enter? It would be great if you share any document reference for non-ES bar charts redirection.

Can you please comment on this so I can close this discussion as most of the information has been provided from your end.

Regards,

Rahul

saparja
Saviynt Employee
Saviynt Employee

Hi @rahul_p ,

For non-ES charts, all V1 analytics (the ones where data is stored in database) controls should show up. It can be SQL query based V1 or runtime V1

If the requirement is to redirect to any specific V1 analytics control history on click of a label value, then the other fields can be left blank, only the label value is needed to be added.

Regards,

Saparja

rahul_p
Regular Contributor II
Regular Contributor II

Hello @saparja ,

Thank you so much for your response, its really appreciated.

Regards,

Rahul

Manu269
All-Star
All-Star

@saparja @uthra_rahul Can you please take a note and add more details around the dashboard in the docuemntation please?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

uthra_rahul
Saviynt Employee
Saviynt Employee

Sure, Manish.