cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Dashboard filter conditional on multiple dimensions

EmoTrans
7 - Data Storage
7 - Data Storage

Hi Everyone,

is there a way to create a dashboard filter like this:

where Origin Country = Germany OR Destination Country = Germany?

Thx for your help!

B RGDS

Hendrik

2 REPLIES 2

Angelina_QBeeQ
10 - ETL
10 - ETL

Hi @EmoTrans ,

You can try Filter Relationship Editor. But this feature is supported with Analytical Engine.
The information about activation for the feature you can fine here L2023.1 Release Notes.

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ  - Gold Implementation and Development Partner



david-h
9 - Travel Pro
9 - Travel Pro

Hi @EmoTrans ,

Not sure if you tried Angelina's solution, which is certainly the most flexible. If it does not work for you, there are solutions based on your data model. For instance in your case you could use one of those two models :

  1. concatenate origin and destination countries => you can then use a filter on string, using "contain" and "or"
  2. use a dimension country with two fields : country name and type with two values : origin or destination

Hope this helps.

Best, David