Forum Discussion
Relationship issues part 2
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.
I do have that extra relation in there of EmployeeID. I wonder if I removed that if it would "fix" the issue?
That should not be of any impact in the current context, as you are not using any columns from that table in the visual or filter, which might impact the underlying data for the three tables.
In recreating what you did using my datasets, I did find that the Ratings "number" is being summarized. When I clicked Do Not Summarize, I lost that other line of data. When I do summarize, it is there. Should I change those rating numbers into Text as they do not need any sums or calculations?
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.
- That did seem to do the trick. Thank you for your help