Jump to content
Software FX Community

Apparent bug when using 3 columns of data in a chart


Recommended Posts

I've got a simple query that returns data on how many things we start and finish each hour. It basically returns something like the following (please forgive the formatting):

hour   starts   completions
----------- ----------- -----------
  0   99 197
  1 4   74
  2 0 3
  3 0 0
  4 0 0
  5   68 0
  6 116 0
  7 119   74
  8   71   56
  9   78 132
10 103   57
11 111 114
12   56 0
13   12   24
14   17 100
15   87 7
16 153 0
17   54 0
18 119 0
19   98 0
20   88   60
21   95 151
22   73   14
23   73   78

As you can see, there is always 24 values returned, and the x-axis should be from 0 to 23 (representing the hour of the day). However, when I try to plot this I get something like the following:

Posted Image 

I'm obviously trying to separate the "starts" from "completions", but I never get all the values of the x-axis displayed. Sometimes it shows 10, but other times it shows 11, so I don't know what's going on here.

Is there something specific I need to do to get this to work? Is this a known issue?

Link to comment
Share on other sites

I put your data in a CSV file and connected it to an X/Y line chart with no problem, getting the 24 points as expected. Please contact me at ivang@online.powergadgets.com (remove online) and I will give you the .pgf and .csv files.

Essentially, I created an X/Y chart using the hour column and the X axis value and the other two columns as Y axis values. Is that what you were doing? Are you using the Creator or the out-chart cmdlet?

Link to comment
Share on other sites

  • 2 weeks later...

I don't have a solution, but we just upgraded to ASE 15, and this problem has gone away. We were running ASE 12.5.3 when this was a problem and I was using the OLEDB method of querying the data. There are a few quirks/differences within 15 from previous versions, but I'm not sure what solved this.

 Thanks for your help. 


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...