1. ephraim ben-eliezer
  2. PowerBuilder
  3. Friday, 11 May 2018 13:26 PM UTC

Trying to change the category axis label text on a graph datawindow to include custom information

Currently I have the category axis text being a date in mmm dd format.   I would like the date to include parens with a integer to show a value at that date.. Something like:

01 May (233)       01 Jun (-234)       01 Jul (-500)

I have the extra value available in another column in my datawindow.

Any ideas how to accomplish this?

Regards,

Ephraim.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 11 May 2018 14:03 PM UTC
  2. PowerBuilder
  3. # 1

Hi Ephraim;

  You will need to create a character based SQL Computed Column that matches the format of the date + number format that you require. You can then map the Value Axis Text to that SQL CC as the display value. That should  give you the value formatting that you need. For example ...

HTH

Regards ... Chris

Comment
  1. ephraim ben-eliezer
  2. Friday, 11 May 2018 15:46 PM UTC
Chris, Did you mean the "Category Axis Text" ?  When I try to it the expression dialog to paste, it does not allow me to put other columns into the expression, only the category, title, seriesaxislabel etc.     (can't seem to get an image to paste here so I can show you)

  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 11 May 2018 15:57 PM UTC
Could be used then on either axis' text property.  It just depends on where you need the specially formatted date. Your choice. 

  1. Helpful
  1. ephraim ben-eliezer
  2. Friday, 11 May 2018 18:04 PM UTC
I still can't get a the axis' text property to show an alternative column... this is my basic problem

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.