Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Year-Month Line Chart ?

  1. #1

    Default Year-Month Line Chart ?

    Hi, is is possible to build a chart as the attached one in PRD? I mean having a kind of Year-Month in the X-axis? It would be great for trend charts across two year for instance.
    Attached Images Attached Images  
    Last edited by leandrob; 09-24-2014 at 10:16 AM.

  2. #2
    Join Date
    Sep 2014
    Posts
    1

    Default

    I am having an issue because my date fields are broken down to the lowest grainual level which includes year, month, day and time in minutes and seconds. How do I just aggregate to either years or months?

  3. #3
    Join Date
    Sep 2014
    Posts
    3

    Default

    I had a similar issue some time ago. What I did was to create an Open formula concatenating the fields "Year" and "Month". Then, you can use this formula in your Chart.
    In my particular case, the formula was:

    Code:
    =["[Calendar].[Month]"] & "-" & ["[Calendar].[Year]"
    I hope it helps you.

    Regards,

    Tatan.

Tags for this Thread

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.