Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Stacked Barchart

  1. #1

    Unhappy Stacked Barchart

    Im trying to create a stacked barchart.

    I have a query:

    select date, region, sum(sales) as sumsales from company_sales group by date, region

    I need to create a serie in stacked bar for each region. But it is only creating one serie (sumsales).

    Atached is a image with a example of the chart that i need...

    i'm sending my xaction too, please guys, could you see whats wrong?? Any sugestion is welcome!

    really thanks!
    Attached Images Attached Images  
    Attached Files Attached Files
    Last edited by Leandro; 05-22-2009 at 04:52 PM. Reason: better explanation

  2. #2


    I found a issue in jira about my problem. But no solutions at all...

    Any Idea??/ Pleaseee
    Last edited by Leandro; 05-25-2009 at 03:01 PM.

  3. #3

    Red face solved

    Hey Guys,
    the solution for that problem is to use the crosstab component:

    Thanks kappa!!

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.