infocaptor logo

In the previous article we added a parameter (Create dashboard Parameter) and now we go on to enable Auto-Refresh.

Dynamic Refresh of Dashboard when changing Parameter

First take a note of the internal identifiers for each of the Graph portlet and Query portlets.

When you click on any portlet, the internal ID is displayed at the bottom in the status bar
Image

The internal ID for 'By Region' portlet is = 'q32'.

Now we will add a trigger in the 'Year' parameter to refresh 'By Region' whenever the user changes or selects a year value

Image

As shown above, edit the 'Year' parameter (right click on 'Year' title, select 'Edit')
Set "Run Dynamic Java Script" = 'Y'
Click on the 'Dynamic Java Script Editor'
Type the following command "//<REFRESH_LIST>q32</REFRESH_LIST>

You can refresh more than one portlet by adding the portlet id separated by comma
e.g. "//<REFRESH_LIST>q32,q34,g35</REFRESH_LIST>

Now if you need to refresh all the portlets then there is an easy shortcut
Just type "//<REFRESH_LIST>ALL</REFRESH_LIST> NOTE: "ALL" is in Caps

Similarly, add the trigger command to the 'Region' parameter

Image

The Dashboard So Far

Image

Next -> Create Dashboard Drills

Click on to boost InfoCaptor's Ego.

It is super easy to create and use Dashboards Online at https://my.infocaptor.com (in the cloud)

OR

If you wish to work within your firewall, you can alsodownload and run dashboards on your computer or server (intranet/network etc)

Posted in Excel | Tagged ,