Oracle Analytics Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Idea Labs› Oracle Analytics Idea Lab

Categories

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

When we add multiple measures, chart should not display if there is no values.

Needs Votes
11
Views
5
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics & AI Lead
in Oracle Analytics Idea Lab

We should have option not show the line for null values.

In Line diagram it is showing all values for all measures even though we don't have values for it. In the attached example, after week 20 , there is no value for green lines. But it is showing continuous line.

In overlay diagram it is showing zero. No option to not to show as Gap.

image.png


image.png


2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Have you tried this option? but I think your request is not for Gap, you are asking that it use the same value as the previous value in case there is a Null. It is different from Gap and should be solved in the definition of the measure/calculations.

    Screenshot 2023-09-12 at 1.23.03 PM.png


  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics & AI Lead

    Yes , My issue is using same value even though it is Null.

    If I plot two different line DVs, it looks below.

    But If I add same measures in one DV, It is not ignoring nulls.

    Can you suggest how it can be solved in Calculation/Measure definition?


    image.png


  • Jorge Olmeda
    Jorge Olmeda Rank 5 - Community Champion

    Hi,

    Same happened to me as well. It would be good to have a solution.

    Best regards,

    Jorge

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    @Rajakumar Burra can you share an example dataset? I was not able to create the same outcome.

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics & AI Lead

    @Jorge Olmeda Do you have any quick example. I am unable to reproduce now.