Forum Discussion
Get value from other table if
Hi, thank you for replying! Sorry for the late response. I made an example with similar data. I want to show, among other things, how many responses I have recieved with the different messages. Something like this:
To maybe simplify things a bit: What I need is how to create the relationship between the tables so that I can study when my respondents reply and to what message I sent out to them. Let's say I send out an email to 100 people, I get 60 responses within the two first days. I then send out a reminder to the remaining 40 people and 25 reply. I then close the possibility for replying on that particular topic. My result is in two tables:
| Type of email | Number of people sent to | Date |
| Main | 100 | 1. january 2022 |
| Reminder | 40 | 3. january 2022 |
| Respondent-ID | Date reply |
| 1 | 1. january 2022 |
| 2 | 1. january 2022 |
| 3 | 2. january 2022 |
| ... | |
| 61 | 3. january 2022 |
Every reply from 3rd of January is considered to be a reply to the reminder, not the first email (I know that is not certain, but that doesn't matter). So how do I combine these so that I can produce charts such as shown in the previous message?