Can we redirect from bar charts to analytic report

[rahul_p]

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

[rushikeshvartak]

All dashboard’s can be made clickable

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

[rahul_p]

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]

can anybody comment on this please?

[Manu269]

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?

[saparja]

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]

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]

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]

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 · Accepted solution]

@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]

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]

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]

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]

Hello @saparja ,

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

Regards,

Rahul

[Manu269]

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

[uthra_rahul]

Sure, Manish.