I would like to display a patient full name on the y axis of my horizontal bar chart and the issue i am running into is duplicate names. I have a unique patient id but do not want to display the patient id. How can i display the full name but have it assigned to that patient id to assure values are not being aggregated for duplicate names that are in fact different patients? Thank you in advance for any help!
If they have the same name then it will be grouped.
The only thing I could think of would be to add an id attached to the full name.
For instance:
John Smith - 1
John Smith - 2
You could use a substring of your patient id to not have the whole id displayed but just enough to distinguish it from another.
concat({patient_name},‘-’,substring({patient_id},1,4))