Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Problem with a chart and its parameters

  1. #1
    Join Date
    Jun 2008
    Posts
    27

    Default Problem with a chart and its parameters

    Hi,

    I want to display the amount of items per day.
    I've got a select for this:

    Code:
    SELECT
    	count(reprobilder.bearbeitungstag) AS AnzahlBilderProTag,
    	reprobilder.bearbeitungstag AS BearbeitunstagSortiert
    FROM
    	reprobilder
    WHERE
    	reprobilder.status = 'Fertig'
    GROUP BY
    	reprobilder.bearbeitungstag
    ORDER BY
    	reprobilder.bearbeitungstag
    Result:
    245 | 06.01.2009
    342 | 07.01.2009
    etc.

    I created a new report.
    Amount and date appear correct in ther text and number field.
    But I can't create a bar chart of the data.
    I click on "edit chart" and insert anzahlbilderprotag in value columns and bearbeitunstagsortiert in series name.
    X axis should be bearbeitunstagsortiert (day) and y axis should be anzahlbilderprotag (amount per day).

    What's my mistake?

    I appended a screen shot.

    Thank you in advance.
    Attached Images Attached Images  

  2. #2
    Join Date
    Jun 2008
    Posts
    27

    Default

    Or the other way round: Is there a good introduction into diagramms / charts with Pentaho?
    I found the user guide and other resources with a very short explanation but it didn't lead to success for my needs

    Is there a resource like a tutorial for showing an amount per day over time?

  3. #3
    Join Date
    Jun 2008
    Posts
    27

    Default

    .. just want to move this to the top ..
    I still need help with creating charts

  4. #4

    Default Prob with chart

    HI!!!!

    Put bearbeitunstagsortiert in category column (i.e the x-axis column) rather than series.
    I think this will solve ur prob.
    Geetika Saxena
    geetika.saxena@infoaxon.com
    InfoAxon Technologies Ltd.
    Noida,India

  5. #5
    Join Date
    Jun 2008
    Posts
    27

    Talking

    Wow .. exactly .. That's what I needed.

    Thank you very much

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.