Hitachi Vantara Pentaho Community Forums
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Refresh Pie Chart in CDE

  1. #1

    Default Refresh Pie Chart in CDE

    Hi,
    I have a pie chart developed using values from mysql DB.Now when I change values in DB it has to reflect on the chart every x seconds that I require,this means the chart has to refresh every x seconds.How can I achieve it?.Presently in Post Execution I use this function:

    function()
    {
    setTimeout(function(){Dashboards.update(render_Pie);},1000);
    }

    But the problem is during refresh if any of the pie piece is selected in the pie chart,the tooltip remains even after the chart is refreshed.

    Kindly help me with a solution to sort out this problem

    Thanks in advance

  2. #2
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    There's a refresh period, you can just use that.

    As for the tooltip, I think we fixed that already
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3

    Default

    Pedro just curious....am I using the old version of CDE?.Where can I find the new version?.I am using CDE - bundle 1.0 RC3

    I do not see a refresh period button for Pie Chart component in the version I have.

    Please help me with a link to download the latest bundle

    Thanks
    Last edited by narayanyr; 03-30-2011 at 08:30 AM.

  4. #4
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  5. #5
    Join Date
    Jun 2011
    Posts
    1

    Default

    Hi,

    I have downloaded the latest build from this link http://ci.analytical-labs.com/jenkins/ and I don't seem to find the refresh period anywhere when editing my dashboard with CDE. Can you tell me where is this refresh period located.

    Thanks

  6. #6
    Join Date
    May 2011
    Posts
    117

    Default

    I think you are able to achieve this by listener , make pie-char on base of some listener , and through java-script make this listener parameter are res-assigned periodically , so chart will re-executed.

    Thanks

  7. #7

    Default Refreshing Charts automatically

    Hi,

    I have a dashboard with one table component and one piechart component.

    In the CDE editor I found the refreshPeriod property for table component, but not for chart component by default.

    So I edited the Dashboard.cdfde file to include the following in the properties of Pie Chart Component

    Code:
    {
          "name": "refreshPeriod",
          "value": "30",
          "type": "Integer"
         }
    After making this change I can view the Refresh Period property even for the chart component in CDE.

    On database change however, only the table data changes, but the pie chart shows stale data.
    I have to refresh the browser page for the pie chart to update.

    Is anybody else able to refresh chart components in any way?

    Is there something I am missing.

    Thanks for any help

  8. #8
    Join Date
    Jul 2007
    Posts
    2,498

    Default

    Jeez - don't touch the cdfde file

    If the property is not there, just add this to preExecution:

    function(){ this.refreshPeriod = 30 }
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  9. #9

    Thumbs up

    Thanks for your reply Pedro.
    This now works for me

  10. #10

    Default

    I am trying this with a CCC Line Chart component but nothing happens. Any leads on what I should do?

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.