Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Report Chart issue

  1. #1

    Default Report Chart issue

    Hi All,

    I have the issues to create the bar chart based on the data as below.
    Name:  report_data.jpg
Views: 20
Size:  13.3 KB


    You can see that Month in the chart is not in the desired ordering which is Jan - Dec. Attached below with the chart setting also. Please advise how to resolve this issue, thank you very much.

    Name:  report chart output.jpg
Views: 21
Size:  11.9 KB
    Attached Images Attached Images  

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Ordering inside PRD is (if I remember correctly) not possible.
    Order the results in the SQL-Statement

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

    Default

    Dont use a categorical chart. Remember Statistics 101? Categorical scales have no order, they only allow comparison on equal or non-equal basis.

    If you want a specific order, use an ordinal scale, and thus the X/Y charts. For instance, use proper dates as value for the x-axis, use the unit "month" and then format it with format string "MMM".
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  4. #4

    Default

    Thanks a lot for the advise, will try with X-Y chart.

  5. #5

    Default

    Hi Taqua,

    I try with Time-series now, but how to set the year as the series so each year will have its own line? Please advise.

    Name:  chart2_data.jpg
Views: 19
Size:  39.4 KBName:  chart2_setting.jpg
Views: 19
Size:  41.4 KBName:  chart2.jpg
Views: 20
Size:  19.6 KB

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.