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.

Your satisfaction is our top priority. If you are not completely satisfied, ask us and we will fully refund your purchase within 60 days.

Your subscription is backed by 100% money back guarantee.

Risk Free - Signup Now for just $29/month

Don't miss this, We offer you an amazing value proposition!

  • Free 60 minutes web consultation. We will look through your data, help and suggest the best way to visualize and most probably build a complete working dashboard. You will be amazed how much can be done in such a short time frame!
  • Absolutely Risk-Free, if you are not completely satisfied we will refund your subscription.
  • Check this step by step tutorial on how to build dashboard

Posted in Excel | Tagged ,