Dynamically hide / show a report in dashboard based on the onclick on the parent report

Dashboard Designer
, , ,
#1

Hello Helical Insight,

I am using helical insight enterprise edition 4.1. What I would like to do is have a dashboard on which the only this first report should be there. As soon as I click on the first report the second report with drill down data should then appear.
How can something like this be achieved?

Thank You,
Sesa.

#2

Hello Sesa,

There are two methods to implement this.
a. Method 1 : this is more straight forward. Read this to understand how to do the same : Show charts with filter values selection in dashboard - Helical Insight

b. Method 2 : Follow the steps mentioned below

Basically you will have the parent report and the child report in the dashboard. And implement inter panel communication so that when you click on the parent report the child report should change.

Apart from that open the adhoc child report in edit mode. That child report will be having a filter. Select “custom” and give it a value so that this specific value does not exist in the database. Then if required you can again switch to Auto mode. By adding a value which does not exist in the DB this report will not return any result set.

image

Then in this report add the below code in JSEditor. Here in this code we have specified that if the respondesata length is zero (which will happen in case if we pass a filter with no matching data) then make the chart div blank.

var id = hi_container.get("renderId");
           var chartId = '#main';
           if(id != ''){
           chartId = chartId+'-'+id;
                          }
           hi_container.set("postExecution",function(c){
             var d = c.get("responseData")
             if(d.data.length == 0){
            $(chartId).html("<div style='font-size:20px; text-align: center; font-weight: bold'>  </div>")
                                                }
              else{
              console.log("Not Empty")
                      }
              });

Save this report. Then go to the created dashboard and you will see the required behavior.
How to implement interpanel communication : Inter-Panel Communication Functionality - Helical Insight

Thank You,
Helical Insight.