Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: how to get multiple value in bar chart.

  1. #1
    Join Date
    Nov 2009
    Posts
    14

    Question how to get multiple value in bar chart.

    Hi all.

    I have my query result as(:

    MONTH PRODTYPE PRODNAME AVG.PRICE HIGHEST LOWEST
    -----------------------------------------------------------------------
    JAN GRAIN RICE 24 25 22
    JAN GRAIN WHEAT 18 18 18
    JAN GRAIN OAT 17 19 16
    JAN GRAIN MAIZE 16 17 16
    JAN DAIRY MILK 21 21 21
    JAN DAIRY CHEESE 110 105 115
    JAN DAIRY BUTTER 195 225 190


    now I have want the bar chart of AVG.PRICE,HIGHEST,LOWEST against PRODTYPE,then how can I get it.

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    You can plot only against one level on the category axis. So you cannot have a prod-type with subtypes prod-name at the moment. As a quick and dirty workaround, you could create a new computed column that combines the two columns and plot against that.

    Then:
    CategoryName = PRODNAME (or your combined column)
    Value-Columns = [AVG.PRICE, HIGHEST, LOWEST]
    Servies by Value = [Avg, High, Low]
    Last edited by Taqua; 12-14-2009 at 11:40 AM.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Nov 2009
    Posts
    14

    Default

    Quote Originally Posted by Taqua View Post
    You can plot only against one level on the category axis. So you cannot have a prod-type with subtypes prod-name at the moment. As a quick and dirty workaround, you could create a new computed column that combines the two columns and plot against that.

    Then:
    CategoryName = PRODNAME (or your combined column)
    Value-Columns = [AVG.PRICE, HIGHEST, LOWEST]
    Servies by Value = [Avg, High, Low]

    Thanks for your reply..
    we can plot against one level on the category axis is applicable to all the charts or there is any chart in which we can still maintain our data in original form.

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.