MSSpline: Put left-most data point on the y-axis

(3 posts) (2 voices)


  1. dharkness, Member

    I have a few charts that graph some amount (counts, revenue, etc.) over the hour of the day. On some charts the 0 hour appears flush with the y-axis while on others the first real data point is off the y-axis and there's a line from the origin to that first data point. It makes it look like there's a data point at (-1, 0)

    Here's a really bad ASCII drawing showing the problem:

    5|  This data point should be on the y-axis
     |  |
    4|  v    -+--+-
     |  +--+/      \
    3| /            +--...
     | |
    2| | <-- This squiggly line should be gone
        0  1  2  3  4  ...
        This marker should also be on the y-axis, at the origin

    This is how I want it to look:

    4|    -+--+-
     +--+/      \
    3|           +--...
     0  1  2  3  4  ...

    As I said, some charts work correctly, but I cannot see a pattern. The only difference is the y-axis values.

  2. myDBR Team, Key Master

    Please send an example report ouput to support using Output as SQL. Will be easier to see what is going on.

    myDBR Team

  3. dharkness, Member

    I finally figured it out (just saw your reply) using the Output to SQL. I was using a RIGHT JOIN to fill in holes in the chart for where there was no data (plotting vs. hour of day), but I was pulling the title/hour from the LEFT table which were NULL on those missing hours.

    Thanks for the pointer. Problem solved. :)


You must log in to post.