You need to sign in to do that
Don't have an account?
Einstein Analytics and Discovery Insights Specialist Challenge 3: How do I calculate subscriber attrition cost?
I am presently stuck on Einstein Analytics and Discovery Insights Specialist Superbadge (https://trailhead.salesforce.com/en/content/learn/superbadges/superbadge_analytics_insights_specialist) Challenge #3
The dashboard designer tells me there is an error in my Attrition Cost step
My SAQL query is this:
What am I missing?
The dashboard designer tells me there is an error in my Attrition Cost step
Warning! Analytics encountered a problem with this step [Attrition_Cost_1]. Input stream not found
My SAQL query is this:
beattieSubscribers = load "Beattie_Subs"; tenuredSubscribers = filter beattieSubscribers by{{row(Tenure_Length_1.selection,[0],["min","max"]).asRange ("Tenure")}}; churnedSubscribers = filter tenuredSubscribers by 'Churn' == "Yes"; attrCost = churnedSubscribers * 950.00;
What am I missing?
1. After filtering the beattieSubscribers for Tenure and Churn, I need to group these.
and then,
2. I needed to generate the attrition cost for each subscriber in the group, and assign the value using "as" syntax, instead of just equals:
All Answers
I have the above SAQL query as the query in the "Attrition_Cost__1" step, which at length looks like this:
However in the Dashboard Designer, on the right, under "Steps with Errors" I see:
If I click "View Error", I see:
FWIW, if I check the challenge -- which I wouldn't actually expect to pass right now -- I get the following error:
Can anyone kindly explain what this error means and an appropriate fix?
1. After filtering the beattieSubscribers for Tenure and Churn, I need to group these.
and then,
2. I needed to generate the attrition cost for each subscriber in the group, and assign the value using "as" syntax, instead of just equals:
This error occurs due to two of the below reasons:
1. Either you have not referenced Attrition Cost with your Reference Line.
2. Or you have not bind your filtered your Reference Line with Tenure Length.
Please check whether you have achieved these steps:
1. Create Attrition Cost query and bind it with Tenure length toggle.
2. Create Subscription Cost query. Create a Referece Line on this chart and choose Attrition Cost query for its Label and Value. You don't need any filter on this Referene Line on the basis of Tenure Length.
Make sure these two steps are achieved and you should be able to pass this challenge.
Mark it as Best Answer if it is helpful for you.