Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Simple Bar Chart...

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Apr 2010
    Posts
    149

    Default Simple Bar Chart...

    Hi,
    I'm using CDE to design a dashboard following these steps:
    1) Create a new dashboard and save it2) Add a new row (R1) to the dashboard
    3) Create a datasource (QRY):


    Code:
    SELECT 
    PRODUCTS.PRODUCTLINE,
    ORDERFACT.YEAR_ID,
    SUM(ORDERFACT.TOTALPRICE)
    FROM PRODUCTS INNER JOIN ORDERFACT ON PRODUCTS.PRODUCTCODE = ORDERFACT.PRODUCTCODE
    WHERE ORDERFACT.YEAR_ID > 2003
    GROUP BY
    ORDERFACT.YEAR_ID,
    PRODUCTS.PRODUCTLINE
    ORDER BY
    ORDERFACT.YEAR_ID ASC,
    PRODUCTS.PRODUCTLINE ASC
    4) Add CCC Bar Chart
    5) Set the Bar Chart Datasource to QRY
    6) Set the HTML object to R1

    When I run the preview this is the result:

    Name:  bar.jpg
Views: 20
Size:  13.1 KB:

    I expected to see year 2004, 2005 on the rows according this query output:

    Name:  qry.JPG
Views: 22
Size:  30.4 KB

    Is there some additional attribute/property to be set?
    Thanks!

  2. #2
    Join Date
    Apr 2010
    Posts
    149

    Default

    I solved!
    "crosstabMode" property was set to "True" value instead of "False".
    Setting it to "False" the result is:

    Name:  bar2.jpg
Views: 23
Size:  13.0 KB

    sorry for disturbing...

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.