Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Columns in bar chart

  1. #1

    Default Columns in bar chart

    I have a table whith two columns (valor1 and valor2) and a primary key (id -> 6 and 5).

    The chart shows three bars for each id but I only want the chart show two columns (valor1 and valor2)

    How can I do it?

            <query-result type="result-set" mapping="query_result"/> 
            <query><![CDATA[select id, valor1, valor2
    from val_table]]></query> 
          <action-type>Bar Chart</action-type>
            <chart-data type="result-set" mapping="query_result"/>
            <image-tag type="string"/> 
              <chart-background type="color">#FFFFFF</chart-background>  
              <plot-background type="color">#EEEEEE</plot-background>  

    How does series name attribute work?
    Attached Images Attached Images  
    Sorry for my bad english, I´m learning
    La Aventura Es La Aventura

  2. #2


    Try removing the 'id' from your select statement. So your statement should be: 'select valor1, valor2 from val_table'.

    Hope this helps.


  3. #3


    I have same problem...I have read all docs about charting reference with no results...i tried to use <series-name> but nothing happened...
    what about? I'm going crazy...

  4. #4
    Join Date
    Feb 2008


    try by-row = true

  5. #5


    It seems to me that I had a similar problem until I explicitly made the title column (the first column) a string instead of an integer. In my case, I wanted to use the year for the grouping title, but it kept plotting the year as one of the charts until I prepended the year with some text (e.g. "FY " for fiscal year).

    Perhaps something like:

    select 'ID: ' + CONVERT(varchar(2), id) as ID, valor1, valor2
    from val_table
    Note that my example uses MS-SQL's convert function; YMMV.
    Have you hugged your computer geek today?

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.