Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: chart is not showing on cde dashbboard

  1. #1
    Join Date
    Sep 2017
    Posts
    9

    Default chart is not showing on cde dashbboard

    hi

    I have pentaho version 7.1. I'm trying to build a bar chart in my CDE dashboard. I'm using sql over jdbc datasource and my database is mysql version 8.42 .
    the problem is that this chart shows nothing!

    here is my datasource configuration


    Name:  12.jpg
Views: 306
Size:  17.1 KB

    and this is my chart configuration


    Name:  32.jpg
Views: 239
Size:  15.0 KB

    is here anything wrong? what should I do to correct this problem?

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    Start by checking logs, both server-side and client side.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3
    Join Date
    Sep 2017
    Posts
    9

    Default

    my query is like:

    select count(id),
    status
    from logs group by status

    the strange thing is that when I'm using this query everything works fine because status data type is integer. but when I replace status by browser (which is of type character varying) pentaho shows nothing!

    I'm using jdbc connection.

    any idea?

  4. #4
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    yeah, make sure your query works and returns results when you're connecting with a standard sql client tool.

    If that's happening, check the Pentaho server logs and client-side logs in the network console of the browser.
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  5. #5
    Join Date
    Sep 2017
    Posts
    9

    Default

    thanks to everybody... I found the problem!

    to show a query on a chart, the query should have a specific format. it's format is :

    select series, category, value from table_name

    as the value is the aggregator (like "count"). by this format the chart is shown.

Tags for this Thread

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.