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

(3 posts) (2 voices)

Tags:

  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
     |/
    1||
     |/
    0+--------------------
        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:

    5|
     |
    4|    -+--+-
     +--+/      \
    3|           +--...
     |
    2|
     |
    1|
     |
    0+-----------------
     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. :)


Reply

You must log in to post.