How can i filter a graph with a colum that is not in the graph — Oracle Analytics

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

How can i filter a graph with a colum that is not in the graph

Received Response
11
Views
3
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

Hi everyone , i try to filter my Graph with " Nomenclature_douaniere"  ( as show in the image below ) , but the graph become empty  ( i think its because i dont use this Column in the graph )

I dont understand why ? is there any way to make a global filter or something like this  ?

pastedImage_1.png

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Provided the filter is compatible with the subject area of the graph then it should work. Are you sure that it is for the same subject area, and are you also sure that the combination of that filter and any filters that were already on the graph that you should still get data?

  • John305
    John305 Rank 5 - Community Champion

    Yes , i did the same filter in Visual analyzer and it works , but in the report it doesnt

    pastedImage_1.png

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    And you have checked that there are no other filters that are already on the report before you apply the new filter?

    If so, go into design mode, import the new filter CONTENT and if it does not return data then remove the elements of the filter one at a time until you see data, then you will have your answer.

    Or, add the logical sql (diagnostic) view to your answers results and then you can review the SQL to sanity check the where clauses of the sql that is being generated.