I have a challenge as to how to arrange my data so I can link tables on 2 fields.
I have a number of tables
1) Registered Users
4) Help Tickets
There are a number of fields in each table but they all have 2 fields i'm most interested in: Date, Email
I would like to be able to filter my graphs by both date / date range and email address.
If you have a separate graph for each table, then no problem, just keep all the fields isolated with different names.
If however you would like a graph where you can show Documents, Chats and Help Tickets all together then you need to have the x-axiz that has a common Date field, and then multiple different expression where you count something relevant for the y-axiz. This is still ok, but if you want to filter by individual user, so filter on an email address, then i run into an issue that i need to link all the tables on 2 fields, which generates synthetic keys etc.