Question

Create a calculated field called Total Payments to Loans
This field represents the proportion of total payments received compared to the
total loan amount. This should be calculated by the sum of the Paid Total
variable divided by the sum of the Loan Amount.

Answer 1

in tableau

Answer 2

Create a calculated field called Payments to Loans Categories
If the Total Payments to Loans is less than 15%, then call it Less than 15%
If the Total Payments to Loans is greater than or equal to 15%, then call it 15% or Greater

Answer 3

Build a horizontal bar chart that shows the total Loan Amount for each Loan
Purpose.
Filter the DTI Level for only Medium and High values.
Sort the Loan Purpose axis by Loan Amount in descending order
Color the chart based on the Payments to Loans Categories field
Add a label to the chart based on the Total Payments to Loans field.
Format this label to a percentage with two decimal places
Change the title of the graph to Loan Purpose: Total Loan Amounts for
Medium/High DTI Accounts <Student Name>

Answer 4

Create a calculated field called Payments to Loans Categories
If the Total Payments to Loans is less than 15%, then call it Less than 15%
If the Total Payments to Loans is greater than or equal to 15%, then call it 15% or
Greater in tableau
kindly correct