Forum Discussion
Helper ITable visual not correct for top row
Hi patkang ,
The Inactive User Table contains User IDs that are in the User Summary Table but not in the Learner Activity Table.
The visual has User ID from Inactive user Table in Rows and Names & Email adress from the User Summary.
This may casued by that there is one or more records of "IDs" in User Summary table, but not in Inactive User Table. Something like below. Please check.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Helper IThanks a lot for your answer
The thing is, I use the User Summary table kind of like a Lookup table but there is only 1:1 relationship since all users only exist once in the model. I tried doing a one fdirection filter but apparently it does not work in a 1:1 relationship.
I tried filtering the visual manually for blanks but that option does not exist. When I call out for the filtering options, it does not recognize a blank.
I would have to filter manually by the name of the person that appears at the top.
Community SupportHi patkang ,
The Inactive User Table contains User IDs that are in the User Summary Table but not in the Learner Activity Table.
The visual has User ID from Inactive user Table in Rows and Names & Email adress from the User Summary.
This may casued by that there is one or more records of "IDs" in User Summary table, but not in Inactive User Table. Something like below. Please check.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.