Forum Discussion

rhuq's avatar
rhuq
Regular Visitor
5 years ago

Visualize sum of values missing from one table by date

Hi PBI community, I have a need to present a visualization of telephony usage in our organisation.  I have one table with all mobile numbers assined to staff, one with landline and associated email a...
Show and Tell
Tips and Tricks
PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

rhuq 

 

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.

rhuq's avatar
rhuq
Regular Visitor
5 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Based on the file that you have shared, please show the exact result which you are expecting.