Hello,
I'm trying to develop a readmission rate dashboard and was able to reproduce the effect I want, based on something I found in an older forum; however, I can't quite cross the finish line.
I'm trying to group readmission rates into 5 categories, that calculates the rate by category against the total number of patient Ids. Where I am stuck is that it's reading each 'Patient ID' individually, and I need to group them according to category, if that makes sense. I've attached a screenshot of what I have so far (current progress) and what I'm trying to achieve (Ideal) If it's more complicated than I think it is, I can mock-up a dummy ,twbx file. Not sure if this is a a Table Calculation issue or Formatting. Please note that I added the borders around the bars for illustration in the 'Current Progress' screenshot. All the items are grouped in the 'Ideal' screenshot.
Many thanks for your help.
Jason
