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

Question

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  ?

Robert Angel · Answer

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.

John305 · Answer

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

Robert Angel · Answer

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?