Creating Repayment Rate by Group
I want to create a chart that shows repayment rate by each customer segment
Repayment Rate = Repayment/Outstanding
I followed this topic (https://dojo.domo.com/discussion/comment/47384/#Comment_47384) because I found a similar solution there, however it didn't show how you'd do it if there's multiple groups you'd like to split the Rate calculation with. I managed to produce the correct calculation, but without groups.
The table I'm going for (no group):
The table where I applied grouping in the ETL:
If there's anyone that could help, that'd be great. Please let me know if you need any details on the dataset, ETL, etc.