Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unable to create relationships between tables

Hello, I have two tables four tables I am trying to use and create relationships for.   1.  Falls table - data table  2.  Patient Days table - data table 3.  Calendar table - lookup table 4.  Loc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

AlexisOlson My # of Patient Days displays correctly, but the same # for patient falls repeats down the column when I try to link them together.  The falls count displays correctly when I have it in a seperate table. 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

If you don't have an "Units" column in the Patients Fall table you will get this. If you do have a Units column in both tables, you need to create a dimension table for Units too. In fact, you should create dimension tables for all fields common to both tables and use the dimension fields in visuals, slicers, measures, filters... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    PaulDBrown I'm confused. 

    Why would I ge this if I don't have an "issue" column in my patient's fall table? --- which I don't! 

     

    I simplified the fields in my tables,  I don't have fields that are common to mulptiple tables except the location and date fields but this didn't resolve the issue.