Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Showing 0 on line graph for no data

Received Response
2
Views
2
Comments
3692314
3692314 Rank 1 - Community Starter
edited Aug 13, 2024 5:33PM in Oracle Analytics Cloud and Server

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

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    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.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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.