Sam
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Sam
-
-
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:
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?
-
I've got a gadget that has two charts in it, and I'm running into an issue where the gadget is not saving its location when closed and reopened. If I remove the second item and save it to a new file with a single chart in it, things work as expected and it starts up where it was closed. I looked into the .pgt file created and everything seems right (location.X = -1920, Location.Y = 1) and there is a ".0.pgt" file created for the second chart in the gadget.
Is there a known bug concerning the location being saved when you have multiple charts in the same gadget?
-
I'm trying to create a scatter plot using the creator application, but I'm getting erratic results. I'm using a SQL data source that returns a result with three columns:
- Location
- Technician
- Priority
What I want to plot is the Priority on the y-axis, location on the x-axis, and then have a series created for each technician found in the data (it can change). From the screen shot below you can see that the mini-preview has the actual data, and is creating different colored series for each technician:
However, you can also see that the main preview is just empty. If I save this as a .pgf and run it I don't get any data either. Now I don't know how I did it, but there was one case where the big preview suddenly had the data as expected, but I can't re-create it.
Am I doing something wrong here?
Apparent bug when using 3 columns of data in a chart
in PowerGadgets Support
Posted
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.
DynamicChart.zip