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.