In Trailhead, while verifying the Super Badge challenge 3 in CRM Analytics, getting the below error.
Dataset used for this challenge is attached here for reference.
CRM Analytics and Einstein Discovery Insights Specialist Challenge 3 Description:
Display Churn by Tenure
Create a ratings chart that displays churn by tenure. Configure the chart to filter by length of tenure.
Error Encountered While Verifying the challenge:
Challenge Not yet complete... here's what's wrong:
We can't confirm the binding syntax for the Churn Tenure chart. Check that toggle widget selections are updating the Churn Tenure chart. Confirm the binding is using the correct step.
Binding Query used in Ratings chat:
q = load "Beattie_Subs";
q = filter q by {{row(static_2.selection,[0],["min","max"]).asRange ("Tenure")}};
q_B = filter q by 'Churn' == "Yes";
result = group q by all full, q_B by all;
result = foreach result generate (count(q_B) / count(q))*100 as 'churnRate';
Toggle Widget Query:
{
"broadcastFacet": true,
"columns": {
"min": {
"type": "string"
},
"Length of Tenure": {
"type": "string"
},
"max": {
"type": "string"
},
"Tenure Length": {
"type": "string"
}
},
"label": "Tenure Length",
"selectMode": "single",
"type": "staticflex",
"values": [
{
"Tenure Length": "High Risk",
"min": 1,
"max": 12,
"Length of Tenure": "1 to 12 months"
},
{
"Tenure Length": "Medium Risk",
"min": 13,
"max": 24,
"Length of Tenure": "13 to 24 months"
},
{
"Tenure Length": "Low Risk",
"min": 25,
"max": 36,
"Length of Tenure": "25 to 36 months"
}
]
}
For quick reference, Custom Definition of Toggle Widget is here below.
Complete Requirement:
Display Churn by Tenure
Beattie Media’s wheeling and dealing to make their newer subscribers happy has also come at a cost to their loyal subscribers, who were there at the beginning. Arnas and Olivia are dismayed to hear their longtime subscribers are feeling ignored and starting to lose their sense of loyalty. These once-steadfast subscribers are also cancelling their services for better deals. Arnas and Olivia would like to monitor churn within subscriber tenure. For example, measure the number of subscribers who’ve been with them for over 2 years and cancelled. They’re asking for a churn by tenure chart to help them be more strategic and targeted for all their subscribers.
- Locate the dashboard section labeled CHALLENGE 2 and replace it with a chart widget.
- Add Churn Tenure as the query name.
- Add a calculation that divides the number of churned subscribers (Churn = "Yes") by the total number of subscribers. Churned subscribers will be the numerator, total subscribers will be the denominator.
- Add a toggle widget above the Churn Tenure chart.
- Add Tenure Length as the display label.
- Add the following custom definition to the widget.
Tenure Length (Display) |Length of Tenure (Value)
High Risk | 1 to 12 months
Medium Risk | 13 to 24 months
Low Risk | 25 to 36 months
Bind the Tenure Length toggle widget to the Churn Tenure chart and have it filter the Tenure field. Your solution should look similar to the example below.
Calculate Subscriber Acquisition Costs
Divya Chauhan (Kcloud Technologies) Forum Ambassador
Hello,
- Super badges are part of the credentialing program,
- Please make sure you Signed up for a free org with special configuration
- Please check prerequisite
- Please Check out the Superbadge Challenge Help article.