Forum Discussion

knight4life's avatar
knight4life
Regular Visitor
5 years ago
Solved

Visual to include values from 2 databases

I am trying to create a report function to analyze our phone system call logs. I have most of it already configured with 1 Table visual that includes User Number, placed calls, missed calls, received...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Yes, this is a standard feature. Use the data model view to link the tables together. Then you can add the needed columns to the visual.

     

     

  • lbendlin's avatar
    lbendlin
    5 years ago

    your "employeedb"  table will act as the dimension table because each user appears there only once, and your "callogdb"  table will act as the fact table as you can have from zero to many calls per user.

    The relationship will be 1:* from employeedb to callogdb, linked by the usernumber.

knight4life's avatar
knight4life
Regular Visitor
5 years ago

lbendlin Ok, so I finally got the visual to show the data properly by changing the username field on the visual to show First. Hopefully my last question is at the bottom it totals up all the columns information and displays the results which is great, but is there a way to exclude that username column from that total row?

 

Thanks,