Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
have a look at my data model in attached.
It was mainly done to show basic income analysis through "Transactions" and a calender.
Every transaction is done for an account, that is related to a person. The person identifier is Épargnants.NEP.
I linked that to a new table: Envois.
That table is basically a list of communications (emails) we sent out, and persons we sent it to, and WHEN that email was sent.
Ex:
| Épargnants.NEP | Nom_envois | Date_envois |
| 1110025584 | We_miss_you | 2020-10-01 |
| 1110035846 | We_miss_you | 2020-10-01 |
| 1110025584 | Let's_have_a_drink | 2020-11-01 |
So I'm looking for a way to show transactions for a person, but only if the date of the transaction follows the date of the communication ("envois").
I'm planning on having selections done for the "Nom_envois", and showing transactions in my graph.
Do I need to rework my model or should I try a set analysis to Show transactions with a date > Date_envois? If I do that and I have more than 1 selection done, thus maybe 2 "date_envois", that doesn't work anymore...
I'm puzzled.
