Forum Discussion

CMSGuy's avatar
CMSGuy
Icon for Helper III rankHelper III
3 years ago
Solved

Relationship issues part 2

Here is the scenario.  I have three tables of data related by EmployeeID and transaction date.  I figured out how to show data in a visual table, but now I have some missing data based on data from o...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    3 years ago

    Summarising should do the work, if you change the change datatype to text and there is multiple entries for same date, it can only show first or last value.

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

Hello CMSGuy 

I have used the same dataset and relationship as you have provided. This shouldn't cause any issue for this requirement. Relationship is based on transaction date.

 

 

The date from the below table visual is from calendar table.

 

Please provide more information if you still feel the issue is not solvable. 

 

Regards,

Naveen 

 

If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

CMSGuy's avatar
CMSGuy
Icon for Helper III rankHelper III
3 years ago

I do have that extra relation in there of EmployeeID.  I wonder if I removed that if it would "fix" the issue?