Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Is there a way to rename columns contents in DB?

  1. #1
    Join Date
    Mar 2017

    Question Is there a way to rename columns contents in DB?

    Hello there
    In my MySQL DB I have an ID column and would like to rename each ID as a different name so when I try to plot a chart, the legend doesn't show the IDs like in the image attached.Name:  pentaho2.jpg
Views: 33
Size:  22.7 KB
    If that's not possible is there a workaround to change the legend name in the chart?
    (Example, id 20 would be Active Power)

  2. #2
    Join Date
    Aug 2016


    I don't really do many charts but I took out an old one I did and was able to do what you were looking for. See screenshot below

    In the series by value section I just typed those names (making sure that they correspond with the order that the data is outputted from the query)

    Name:  Chart.PNG
Views: 29
Size:  11.6 KB

    Name:  Chart 2.jpg
Views: 31
Size:  16.8 KB
    Last edited by Deanicus; 03-07-2017 at 09:29 AM.

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.