Hi, we have developed an app for eletronic medical registering and all patients have an ID.
Now we’re struggling to display the data in statistics because we, everytime, need to group those data by this ID and we arent finding the correct expression/constraint or data structure to create charts and all sorts of display.
Remember that there are multiple repeated information for each ID, because it will always copy the medical records and we have to group all that same data to count as one.
In summary: we have many QUALITATIVE repeated information for every patient. We need to group those to count as one AND group the data referred to each ID (ex: patient ID 123 has meningitis, we need to count the multiple entries of the value MENINGITIS to count as ONE disease and group all entries of ID 123 at the same time).
Please help, thanks!