• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • change the category axis label text on a graph datawindow

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved change the category axis label text on a graph datawindow

  1. Issue
0
Votes
Undo
  1. ephraim ben-eliezer
    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.

  1. Build
PSR files from PB 10 to Appeon infomaker
Error in saving to pdf
Responses (1)
Chris Pollach @Appeon
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
ephraim ben-eliezer
  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
Chris Pollach @Appeon
  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
ephraim ben-eliezer
  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.