Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Bar Chart drill down question

  1. #1
    Join Date
    Sep 2006

    Default Bar Chart drill down question

    I'm building a sales dashboard and could use some help returning the correct drill down value from a bar chart. Given the method call below:

    parameters.setParameter( "drill-url", "SalesDashboard.jsp?salesrep="+salesrep+"&month={SERIES}" );

    Are there any other values I could use besides SERIES? For example, I want to return the month number instead of the series (which is Booked or Quota). The attached jpeg is a screen shot of the chart I have and from the tool tip you can see that the month is 04. How do I get it to return 04 when the user clicks on the bar?


  2. #2
    Join Date
    Sep 2006

    Default Re:Bar Chart drill down question

    After a bit of sleep and a clearer head, I found the solution this morning. Changing the line to read:

    parameters.setParameter( "drill-url", "SalesDashboard.jsp?salesrep="+salesrep+"&month={MONTH}" );[/b]

    and adding:

    parameters.setParameter( "SALESREP", salesrep );
    parameters.setParameter( "outer-params", "SALESREP" );

    parameters.setParameter( "MONTH", month );
    parameters.setParameter( "inner-param", "MONTH" );

    did the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.