Filter on 2 (or more) date fields from unrelated tables

[TLambart]

Hello,

I'm having trouble getting my head around how to work this case :

I have a table named VENTES_COMMANDES which represents the orders made by customers.

I have another table named FOURNISSEURS_COMMANDES representing the orders made to suppliers.

In each of these tables, I have a date field respectively 'Commande_date' and  'Fournisseur_commande_Date'.

These 2 tables are not directily linked as shown by the data model below.

How could I model this so that, in the visualizations part, I could filter the orders made by customers and the orders made to suppliers using the same filter?

e.g.: I want to show in 2 different KPIs the sum of orders made by customers and the sum of orders made to suppliers for  october 2020

Thanks in advance for you help 🙂

 

[Taoufiq_Zarra]

Bonjour, @TLambart 

si j'ai bien compris.

je n'ai regardé en détail le DataModel, mais tu peux concaténer les deux table et tu ajoutera un champs qui distingue si c'est une commande client ou fournisseur.