1. ephraim ben-eliezer
  2. PowerBuilder
  3. Friday, 11 May 2018

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 Accepted Answer Pending Moderation
0
Votes
Undo

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
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. ephraim ben-eliezer
  2. Friday, 11 May 2018
Could be used then on either axis' text property.  It just depends on where you need the specially formatted date. Your choice. 

  1. Chris Pollach
  2. Friday, 11 May 2018
I still can't get a the axis' text property to show an alternative column... this is my basic problem

  1. ephraim ben-eliezer
  2. Friday, 11 May 2018
There are no comments made yet.
  1. Friday, 11 May 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


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