So I do not even know where to begin with this set-up. I have Patient numbers. Each patient number has up to 4 mice under it. Each mice will have multiple Dates with recorded Sizes as entry. I would ideally like to make scatter charts for each Patient number based off the data I put into FM. That way the table would be Size on the y-axis, Date on the x-axis, and there would be up to 4 different color dots scattered on the chart representing the 4 different mice.
Is this even possible? If so, what would be the cleanest way to set this up (what should be fields vs layouts vs tables)? Again I just want one scatter chart per Patient number, but having the 4 mice on it.