Jump to content
Software FX Community

Sam

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by Sam

  1. 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?

  2. 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?  

  3. 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:

     Posted Image
     

    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? 

    BoxPlot Demo.zip

×
×
  • Create New...