Forum Discussion
Visualize sum of values missing from one table by date
Community ChampionCan you please create a mockup sample dataset (in Excel for example) replicating the tables? It's hard to envisage the setup.
You can upload the sample file to a cloud service (onedrive, Google Drive, Dropbox...) and share from there.
Thanks,
Thanks PaulDBrown , I've added a sample here:
https://drive.google.com/file/d/1FsfDTnj2eXWrQ2NkvAK9-34ZKyJ0NEkI/view?usp=sharing
Each sheet replicates what I have in my tables. In the Calls tables I use the "CleanSource" and "CleanDestination" columns, which I derived to have a consistent format for calls - landline, mobile or email (for skype calls). Does it make sense as to what I'm trying to do?
- PaulDBrown
Thanks for the sample. I do not however see what the association is between the tables. Which columns/fields from the phone number and mobile number are associated to the calls table? (If any of course)
What would help is if you posted a depiction of the visual you are trying to recreate (an Excel mockup for example) and which are the relevant fields from each table.
Hi PaulDBrown in the PhoneNumbers table, the PhoneNumber and Email address is linked to both the CallSource and CallDestination columns in theCalls table, as is the MobileNumber column from the MobileNumbers table. This is because calls can come from either a landline number, a mobile number, or a skype account which is associated to the email address.
- Ashish_Mathur
Super User
Hi,
Based on the file that you have shared, please show the exact result which you are expecting.
