Apex Code Development You need to sign in to do that
Don't have an account?
Trail Wave Desktop Exploration, 1. Become a Data Explorer
I keep getting
Challenge Not yet complete... here's what's wrong:
The 'Top Laptop Industry' lens was not found. Please follow the requirements and ensure everything is setup correctly
I have named the Lens as step 2 - Enter D01 - Laptops Salespeople - Wall of Fame as the title AND/OR result set Top Laptop Industry
Neither seem to work. I have refresed the screen, even cleared cookies and rebooted the computer.
Challenge Not yet complete... here's what's wrong:
The 'Top Laptop Industry' lens was not found. Please follow the requirements and ensure everything is setup correctly
I have named the Lens as step 2 - Enter D01 - Laptops Salespeople - Wall of Fame as the title AND/OR result set Top Laptop Industry
Neither seem to work. I have refresed the screen, even cleared cookies and rebooted the computer.
create Your First Wave Analytics App Name called "My Exploration" Please find the below link.
https://trailhead.salesforce.com/wave_analytics_basics/wave_get_ready_for_trail
Once App is created Assign the app to "Top laptop Industry" .please check the image below.
I hope it will be helpful.
Please mark it as solved.so they removed from unanswered questions.and more appear as the proper solution to similar kind of issue.
Best Regards
RahulKumar
How do I mark a question as answered?
What you had above, it one of my many attempts. I tried every permutation and made sure that the following was set accurately...
Dataset: DTC Opportunity
Add Group:Industry
Add Group: Product Name
Change Measure: Count of Rows to Sum of Amount
Sort by: Dsc (Descending)
Filter by: Product Family Equals Laptops
Filter by: Won Equals True
Chart Type: Stacked Bar
Lens Name: Top Laptop Industry
App: My Exploration
As it is in this case... I tried different configuration for the lens, saved and launched the connection from Trailhead to make sure the integration is working.
Details for setting up lens:
"You're concerned about laptop sales and want to see which industry is bringing in the most revenue. Explore the DTC Opportunity dataset, group by Industry, then group by Product Name. Note that grouping order matters! Measure the sum of amount and sort from high to low. Show only won opportunities for the Laptop product family. Change the chart type to Stacked Bar, then save the lens as Top Laptop Industry in the My Exploration app you created earlier.
Dataset: DTC Opportunity
Add Group: Industry
Add Group: Product Name
Change Measure: Count of Rows to Sum of Amount
Sort by: Dsc (Descending)
Filter by: Product Family Equals Laptops
Filter by: Won Equals True
Chart Type: Stacked Bar
Lens Name: Top Laptop Industry
App: My Exploration"
Error:
"Challenge Not yet complete... here's what's wrong:
The 'Top Laptop Industry' lens does not appear to have the correct query. Please check the requirements and ensure everything is setup correctly."
Getting the same error as above, however during this module my screen is different to those shown in trailhead. See below
I cannot find the Sort by: Dsc (Descending) option on my screen.
Please help!
Thanks!
It looks like there's an update in the UI between April and June. I've tried recrating the lens and adding a description, but nothing works. Any assistance would be greatly appreciated.
Luis
q = load "DTC_Opportunity_SAMPLE";
q = filter q by 'Product_Family' == "Laptops";
q = filter q by 'Won' == "true";
q = group q by ('Industry', 'Product_Name');
q = foreach q generate 'Industry' as 'Industry', 'Product_Name' as 'Product_Name', sum('Amount') as 'sum_Amount';
q = order q by 'sum_Amount' desc;
q = limit q 2000;
Thanks for reaching us. Sorry for the inconvenience. There is an issue with this module. Our team is working on it to fix the issue. We will update you once the issue fixed.
----
let's hope it would be fixed soon but anyways,we can move on to the next modules and get back to complete the challenge here once it's fixed.
Thanks!
\Carlo :)
It looks like this is not fixed yet. i have tried this morning and still receiving the same message.
Once again, we're really sorry for the trouble. I know you all worked really hard for your badges and our errors blocked you from getting them. Appreciate the patience and determination. Please continue to raise issues if you have problems with challenges. Thanks!
When @pchoi says "It's also important to follow the order of the challenges", he means it!
I was getting the 'lens does not appear to have the correct query' error, even after the above announcement that the challenge was fixed. My query looked correct -- but I knew that I had added the "Product Name" Group By first mistakenly (before adding the "Industry" Group By). Even though I deleted the "Product Name" group by (so that Industry was now first), and then re-added it, I got the malformed query error above.
I deleted my lens, started from scratch, and all worked well.
Any help is appreciated!
Would be good to get this sorted out...
I have exactly the same issue: "Challenge Not yet complete... here's what's wrong:
The 'Top Laptop Industry' lens does not appear to have the correct query. Please check the requirements and ensure everything is setup correctly."
While I fulfilled correctly the requirements so far.
I read the thread and an another one related to same training but on mobile (https://developer.salesforce.com/forums/?id=9060G000000I3clQAC)
I recreated Application "My exploration", deleted the lenses created for each try and recreated it again. The only point is that I am using a different account as trailhead to use the Developper Edition but it should not be a problem.
Could you please help ? I am a bit frustrated not to validate this training...
Thanks in advance.
Deleted and recreated the lens from scratch following the exact order in the guide worked for me like @JPSeabury and @Yoma Uttad already pointed out.
Thank you!!!
Thanks in advance.
Delete the lens.
Create the lens again by following steps in same order.
When Saving the Lens, use the name "Sales Pipeline Overview" in the name and description.
Save.
Delete all Lens named Top Laptop Industry and follow order 1 to 10
You will pass.
1. Dataset: DTC Opportunity
2. Add Group: Industry
3. Add Group: Product Name
4. Change Measure: Count of Rows to Sum of Amount
5. Sort by: Dsc (Descending)
6. Filter by: Product Family Equals Laptops
7. Filter by: Won Equals True
8. Chart Type: Stacked Bar
9. Lens Name: Top Laptop Industry
10. App: My Exploration"
Same here, deleted all previous lenses followed the steps again in order and still received error, added a simple description and passed.
HI guys i m facing same issue and followed all solutions in this post but still getting error.Would please help me on this
{
"name": "Top_Laptop_Industry",
"label": "Top Laptop Industry",
"visualizationType": "stackhbar",
"state": {
"steps": {
"aggregateflex": {
"type": "aggregateflex",
"visualizationParameters": {
"visualizationType": "stackhbar",
"options": {}
},
"datasets": [
{
"id": "0Fb1t000000Ce7cCAC",
"name": "DTC_Opportunity_SAMPLE",
"label": "DTC Opportunity",
"url": "/services/data/v43.0/wave/datasets/0Fb1t000000Ce7cCAC"
}
],
"useGlobal": true,
"isGlobal": false,
"selectMode": "multi",
"broadcastFacet": false,
"receiveFacet": false,
"query": {
"measures": [
[
"sum",
"Amount"
]
],
"groups": [
"Industry",
"Product_Name"
],
"filters": [
[
"Product_Family",
[
"Laptops"
],
"in"
],
[
"Won",
[
"true"
],
"in"
]
],
"order": [
[
"sum_Amount",
{
"ascending": false
}
]
]
}
}
},
"widgets": {
"aggregateflex_chart": {
"type": "chart",
"parameters": {
"visualizationType": "stackhbar",
"autoFitMode": "keepLabels",
"theme": "wave",
"step": "aggregateflex",
"title": {
"label": "",
"fontSize": 14,
"subtitleLabel": "",
"subtitleFontSize": 11,
"align": "center"
},
"showValues": true,
"axisMode": "multi",
"dimensionAxis": {
"showAxis": true,
"showTitle": true,
"title": "",
"customSize": "auto",
"icons": {
"useIcons": false,
"iconProps": {
"column": "",
"fit": "cover",
"type": "round"
}
}
},
"measureAxis1": {
"sqrtScale": false,
"showAxis": true,
"customDomain": {
"showDomain": false
},
"showTitle": true,
"title": ""
},
"measureAxis2": {
"sqrtScale": false,
"showAxis": true,
"customDomain": {
"showDomain": false
},
"showTitle": true,
"title": ""
},
"legend": {
"show": true,
"showHeader": true,
"inside": false,
"descOrder": false,
"position": "right-top",
"customSize": "auto"
},
"tooltip": {
"customizeTooltip": false,
"showDimensions": true,
"dimensions": "",
"showMeasures": true,
"measures": "",
"showPercentage": true,
"showBinLabel": true
},
"trellis": {
"enable": false,
"showGridLines": true,
"flipLabels": false,
"type": "x",
"chartsPerLine": 4,
"size": [
100,
100
]
},
"applyConditionalFormatting": true,
"exploreLink": true,
"columnMap": {
"trellis": [],
"plots": [
"sum_Amount"
],
"dimensionAxis": [
"Industry"
],
"split": [
"Product_Name"
]
},
"normalize": false
}
}
}
},
"datasets": [
{
"id": "0Fb1t000000Ce7cCAC",
"name": "DTC_Opportunity_SAMPLE",
"url": "/services/data/v43.0/wave/datasets/0Fb1t000000Ce7cCAC"
}
]
}
I was getting the same error again and again. Apparently the order matters.
Follow the steps in the order as they have been defined in the challenge... I have followed the same approach, instructions and as the result I have cleared the challenge...
steps:
Dataset: DTC Opportunity
Chart Type: Stacked Bar
Bars: Industry
Bar Segments: Product Name
Bar Length: Sum of Amount
Sort: Descending
Filters: Product Family Laptops
Filters: Won true
Lens Name: Top Laptop Industry
App: My Exploration
follow these steps one by one and if you are having any pre added lenses in your My Exploration app then delete all of them and save the current lens and run the app.
Below is the query:
q = load "DTC_Opportunity_SAMPLE";
q = filter q by 'Product_Family' == "Laptops";
q = filter q by 'Won' == "true";
q = group q by ('Industry', 'Product_Name');
q = foreach q generate 'Industry' as 'Industry', 'Product_Name' as 'Product_Name', sum('Amount') as 'sum_Amount';
q = order q by 'sum_Amount' desc;
q = limit q 2000;
Thanks and Regards,
Akash Garg
Please like and share if I am able to help you with my answer.
The challenge is failing because of the sequence with which filters are selected. Rest of steps can be in any order.
If you select 'Won' == "true" as a first filter and 'Product_Family' == "Laptops" as a second filter, it results into following query
q = load "DTC_Opportunity_SAMPLE";
q = filter q by 'Won' == "true";
q = filter q by 'Product_Family' == "Laptops";
q = group q by ('Industry', 'Product_Name');
q = foreach q generate 'Industry' as 'Industry', 'Product_Name' as 'Product_Name', sum('Amount') as 'sum_Amount';
q = order q by 'sum_Amount' desc;
q = limit q 2000;
whereas if sequence of adding filters is reversed, then resultant query would be as fllows
q = load "DTC_Opportunity_SAMPLE";
q = filter q by 'Product_Family' == "Laptops";
q = filter q by 'Won' == "true";
q = group q by ('Industry', 'Product_Name');
q = foreach q generate 'Industry' as 'Industry', 'Product_Name' as 'Product_Name', sum('Amount') as 'sum_Amount';
q = order q by 'sum_Amount' desc;
q = limit q 2000;
Trailhead bots are checking for this exact query for challenge to be completed.
I am not sure of these queries have any performance implications, but if there is any, then second query looks more optimal.
I followed the following steps menitoned by "Mukesh Gupta 38" and able to complete sucessfully
******Delete all Lens named Top Laptop Industry and follow order 1 to 11******
1. Dataset: DTC Opportunity
2. Add Group: Industry
3. Add Group: Product Name
4. Change Measure: Count of Rows to Sum of Amount
5. Sort by: Dsc (Descending)
6. Filter by: Product Family Equals Laptops
7. Filter by: Won Equals True
8. Chart Type: Stacked Bar
9. Lens Name: Top Laptop Industry
10. Description : Top Laptop Industry
11. App: My Exploration"
I have tried 5 times but getting the same issues. Please help me out.
Thanks,
Harsha Naik.