Is it possible to automatically filter a graph ?

[former_member199732]

Hello,

I do not want null values in the graph, and I don't want to exclude them manually.

There is a solution?

Regards,

Thierry

[TammyPowlas · Accepted solution]

What is your data source?

[former_member199732 · Accepted solution]

My datasource is  SAP BI PLATEFORM  (Bex)

[TammyPowlas · Accepted solution]

Can you try excluding them at the BEx Query level?

[former_member199732 · Accepted solution]

Sure i can.

In my Bex i have Revenue and Cost, i want in Lumira a graphic for Revenue and an another for Cost.

If i filter in Bex => 2 datasource

I don't want it.

Regards

Thierry

[TammyPowlas · Accepted solution]

Thierry: one more idea - could you add the dimension as a prompt so when the user goes into it they can filter out the nulls?

[TammyPowlas · Accepted solution]

Thierry:

Here is a screen shot of my suggestion; it is working for me.  I assume you are using Lumira 1.30?

For me the nulls are "not assigned" and I filter "not in list" for not assigned

[former_member199732 · Accepted solution]

Thanks!