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.
Answers
-
If you don't want the groups have you removed the partitions from your window function to get a total across your entire dataset? Or if you're wanting to calculate a total within a group with multiple criteria have you added those additional fields in the partition clause?
What specifically do you mean by "splitting the rate calculation" with multiple groups? What are these groups? Do you need to group by those groupings in your ETL?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive