Forum Discussion

Spencer's avatar
Spencer
Icon for Helper II rankHelper II
10 years ago

Relationships and Slicer

Hi   I'm trying to sort out the relationships shown in my screenshot below in order to get my DeptCode slicer working with my sumabsenthrs measure on the visual level.   My sumabsenthrs measure s...
Need Help
Spencer's avatar
Spencer
Icon for Helper II rankHelper II
10 years ago

Sorry for taking your time but I have managed to solve the issue. I changed the relationship between my Payroll and Payroll Transactions to be row id to pfh_pay_date instead of rowid to rowid. It was actually an issue with the DateTable and not the DeptTable my apoligies.

The measures are slicing by both the Date and Dept now!

I did spot the problem when I went through your second question so thankyou very much for your assistance.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

No problem, glad asking the dumb questions led to the solution!

  • Spencer's avatar
    Spencer
    Icon for Helper II rankHelper II
    10 years ago

    Hi Greg_Deckler

     

    Sorry to bring you back to this topic but I've just realised my problem isn't fully resolved.

    Only a small selection of departments are being sliced, and the rest are being lumped into a (blank) category when visualsied.

     

    I've gone back to your first reply and when slicing by the DeptCode, the Payroll table with row_id dosen't slice correctly on all departments.

     

    Thanks

     

    Here's an updated screenshot: (Employee Master contains each employees current department in em_department)
    Relationships w EM table