Showing 0 on line graph for no data

Question

Hi All,

we have a line graph that does not go to 0 when we have 0 value (e.g. no revenue that week) instead it jumps to the next week that has data.

For example: 5th to 6th week do not return any data from the query as there was no revenue.

I need that line to go to 0 on 6th and 7th week as a real representation of what happened. We do not want to insert dummy lines as this is a very huge table and also will be a maintenance headache.

Thanks in Advance,

MOH

Jerry Casey · Answer

You can insert dummy lines right in the analysis using a union.  In my case, I added a "Week of the Year" column, a zero value for the graphed column, and null values for all other columns.  Filter on the previous year for weeks less than week-of-current date.  Use external columns ("saw_x" calculated columns) that sum by week of year for the graph.

Joel Acha · Answer

Zero and NULl aren’t the same. You’d have to ensure that you have an actual Zero value for it to be plotted. If you need it plotted then you’d need to have a zero value in your fact table.