I was able to complete Data Preparation Super badge, now I am doing Einstein Analytics and Discovery Insights Specialist and stuck at step # 3 (Calculate Subscriber Acquisition Costs)Challenge Not yet complete here's what's wrong:We can't confirm the Subscriber Revenue chart is filtering by the Tenure Length toggle. Any insight you may be able to provide would be great. BTW thanks. Trademarks are property of their respective owners. Check the challenge and confirm the node name and required fields{ "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": " (Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Calculate Acreage", "computedFields": [ { "type": "Numeric", "name": "LowTemp", "label": "LowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "precision": 18, "scale": 2 }, { "type": "Numeric", "name": "HighTemp", "label": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "precision": 18, "scale": 2 } ] } }, contd"Add Temp Class": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Define Temp Range", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "case when Temperature < \"25\" then \"Polar\" \nwhen Temperature >= \"25\" and Temperature <= \"50\" then \"Cool\" when Temperature >= \"51\" and Temperature <= \"85\" then \"Continental\" \nwhen Temperature > \"85\" then \"Tropical\" \nend", "precision": 18 } ] } }, "Augment Temp Class": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Add Temp Class", "relationship": "Climate", "right": "Load Temp Class Mapping", "left_key": [ "TempClass" ], "right_key": [ "TempKey" ], "right_select": [ "TempClass" ] } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "fields": [ { "name": "HighTemp" }, { "name": "LowTemp" }, { "name": "TempClass" } ], "source": "Augment Temp Class" } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "source": "CleanUp", "alias": "Seed_Bank", "name": "Seed Bank" } }}. I understood! When validating the challenge, i'm getting an error stating this:-"Challenge Not yet complete here's what's wrong:We can't find the Seed Bank dataset or required fields are missing. Check the challenge and confirm the node name and required fields. 'Load Seed Bank Agencies w/Climate Data'{ "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end", "label": "TempClass", "type": "Text" } ] } }, "Filter Agency Records": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "AccountNumber" }, { "name": "Name" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingPostalCode" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "Phone" } ], "object": "Account" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Augment TempClass" } }, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Add Agency Fields": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Account", "left_key": [ "AccountNumber" ], "right_select": [ "Acres", "Currency", "Latitude", "Longitude", "Region", "SubRegion" ], "right": "Load Agency Detail", "relationship": "AgencyDetail", "operation": "LookupSingleValue" } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date_Year:R:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "ID Agency Records": { "action": "computeExpression", "parameters": { "source": "Add Agency Fields", "mergeWithSource": true, "computedFields": [ { "name": "IsAgency", "saqlExpression": "case when Phone is not null then \"TRUE\"else \"FALSE\" end", "label": "IsAgency", "type": "Text" } ] } }}Close. (Trailhead Baby was 'gone fishing' this weekend, and didn't check for comments! Thank you. After you've imported the Account object, you'll be ready to tackle the challenges. @trailhead baby,i just updated one alias name in above postsfrom :::"name": "Seed Bank","alias": "seed_bank"to:::"name": "Seed Bank","alias": "Seed_Bank"and re ran the dataflow still have the same old issue no progress ! "I'm publishing my JSON file just to see what I'm really missing (I would really appreciate if someone knows what's going on), { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Filter 2015", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "case when Temperature < 25 then \"Polar\" when Temperature >= 25 and Temperature <= 50 then \"Cool\" when Temperature >= 51 and Temperature <= 85 then \"Continental\" when Temperature > 85 then \"Tropical\" end ", "label": "TempClass", "type": "Text" } ] } }, "Filter Agency Records": { "action": "filter", "parameters": { "filter": "IsAgency:EQ:TRUE", "source": "ID Agency Records" } }, "Load Account": { "action": "sfdcDigest", "parameters": { "fields": [ { "name": "Name" }, { "name": "AccountNumber" }, { "name": "Phone" }, { "name": "ShippingCity" }, { "name": "ShippingCountry" }, { "name": "ShippingState" }, { "name": "ShippingStreet" }, { "name": "ShippingPostalCode" } ], "object": "Account" } }, "Create Seed Bank Agencies": { "action": "sfdcRegister", "parameters": { "rowLevelSecurityFilter": "", "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "Augment TempClass" } }, "Load Climate": { "action": "edgemart", "parameters": { "alias": "Global_Climates" } }, "Add Agency Fields": { "action": "augment", "parameters": { "right_key": [ "AccountNumber" ], "left": "Load Account", "left_key": [ "AccountNumber" ], "right_select": [ "SubRegion", "Region", "Longitude", "Latitude", "Currency", "Acres" ], "right": "Load Agency Detail", "relationship": "AgencyDetail", "operation": "LookupSingleValue" } }, "Filter 2015": { "action": "filter", "parameters": { "filter": "Date:EQ:2015", "source": "Load Climate" } }, "Augment TempClass": { "action": "augment", "parameters": { "right_key": [ "Country" ], "left": "Filter Agency Records", "left_key": [ "ShippingCountry" ], "right_select": [ "Temperature", "Date", "Country", "TempClass" ], "right": "Add Temp Class", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Agency Detail": { "action": "edgemart", "parameters": { "alias": "Agency_Detail" } }, "ID Agency Records": { "action": "computeExpression", "parameters": { "source": "Add Agency Fields", "mergeWithSource": true, "computedFields": [ { "name": "IsAgency", "saqlExpression": "case when \"Phone\" is not null then \"TRUE\" else \"FASLE\" end", "label": "IsAgency", "type": "Text" } ] } }}. I was able to complete the challengeFor Agency Temp Class Lens values should be - Continental - 155(and Polar - 120, Cool - 66)For Seed Bank Temp Class Lens Values should be - Continental - 26(and Cool - 15)You would only focus Continental in the lens before Saving. Salesforce Data Analytics let us help you become a data driven organization and ensure your data is working hard for your business, This includes implementionSalesforce consulting companiesSalesforce ServicesStaff augmentation companiesSalesforce integration companiesSalesforce Implementation servicesSalesforce Health CheckSalesforce DevOpsManaged project services. If you are short on time, start around the 20 minute mark. Hint - The TempClass formula is different for each of the dataflows. Still stuck? I only see one temp.class on my lens- just the one with 155. Superbadge-Data-Integration-Specialist/Challenge #5/ProjectRESTService.cls Go to file Cannot retrieve contributors at this time 40 lines (33 sloc) 1.12 KB Raw Blame @RestResource ( urlMapping = '/project/*') global class ProjectRESTService { @HttpPost global static String postProjectData ( String projectRef, String projectName, I have invested a lot of time solving the step 6 but seems no luck from last 2 weeks.Challenge Not yet complete here's what's wrong:We can't validate the 'Create Seed Bank Agencies' node was created correctly. JSON for filter node:"Filter 2015": { "action": "computeExpression", "parameters": { "source": "Load Climate", "mergeWithSource": true, "computedFields": [ { "saqlExpression": "Date_Year:EQ:2015", "name": "Date_Year", "label": "Date_Year", "type": "Text" } ] } },Thanks, I have the action as "filter", not "computeExpression". There is not a field named Acreage in the zip file - It is a field you create by calculation within the data flow. If you could just post the JSON for your data flow, I will take a look. Reports Accounts by Market To create the "Market" row grouping, use a bucket field. "Create Seed Bank": {"action": "sfdcRegister","parameters": {"source": "Calculate Acreage","alias": "Seed Bank","name": "Seed_Bank"Wrong alias and name. First of all , thanks for prompt reply. I am stuck on creating the test class for the challenge 4 in a propper way. I have the same nodes as you. Hi , Load Seed Bank w/Temperature Classification when ran ,getting an error like below" The dataflow was completed, but the LookupSingleValue node didn't augment any columns. I have higher numbers for all. No. The error is in this - A name/alias is not correct:"Create Seed Bank": {"action": "sfdcRegister","parameters": {"name": "Create Seed Bank","alias": "Create_Seed_Bank","source": "Calculate Acreage". Either the node didn't find any matches, or a join key contains only null values. Open Support Cases You ma, I might complain about my brother sometimesespecially how he takes up so much of mom's timebut I've decided that he really is a nifty fellow. I couldn't get through challenge 3 because I changed them to dimensions, and then now I had to change them back! The trickiest part is the formulas for Definie Temp Range and Add TempClass. I have the same nodes as you, but I dont understand how you are supposed to multi join or the two nodes before that. If you could kindly give me some insight as i fear i'm missing something here. (IE- I don't see it in your right select) I also have one additional character in this SAQL"saqlExpression":"casewhenPhoneisnotnullthen\"TRUE\"else\"FALSE\"end", Eureka! Hi ,i am getting " The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Check the challenge and confirm the node name and required fields. This would take away from the purpose of the superbadge. Processes. { "Add Temp Class": { "action": "computeExpression", "parameters": { "source": "Define Temp Range", "mergeWithSource": true, "computedFields": [ { "defaultValue": "Continental", "name": "TempClass", "saqlExpression": "\"case when Temperature < 25 then \\\"Polar\\\" when Temperature >= 25 and Temperature <= 50 then \\\"Cool\\\" when Temperature >= 51 and Temperature <= 85 then \\\"Continental\\\" when Temperature > 85 then \\\"Tropical\\\" end\"", "label": "TempClass", "type": "Text" } ] } }, "Calculate Acreage": { "action": "computeExpression", "parameters": { "source": "Load Seed Chart", "mergeWithSource": true, "computedFields": [ { "precision": 18, "name": "Acreage", "saqlExpression": "(Seeds_Pound*Spacing)/6272640", "scale": 6, "label": "Acreage", "type": "Numeric" } ] } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "name": "Seed Bank Agencies", "alias": "seed_bank_agencies", "source": "CleanUp" } }, "Load Seed Chart": { "action": "edgemart", "parameters": { "alias": "Seed_Chart" } }, "Augment Temp Class": { "action": "augment", "parameters": { "right_key": [ "TempClass" ], "left": "Add Temp Class", "left_key": [ "TempClass" ], "right_select": [ "TempKey", "TempClass" ], "right": "Load Temp Class Mapping", "relationship": "Climate", "operation": "LookupSingleValue" } }, "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping", } }, "CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "source": "Augment Temp Class", "fields": [ { "name": "HighTemp" }, { "name": "LowTemp" } ] } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "source": "Calculate Acreage", "mergeWithSource": true, "computedFields": [ { "defaultValue": "0", "precision": 18, "name": "LowTemp", "saqlExpression": "string_to_number(substr(Temperature, 1, 2))", "scale": 2, "label": "LowTemp", "type": "Numeric" }, { "defaultValue": "0", "precision": 18, "name": "HighTemp", "saqlExpression": "string_to_number(substr(Temperature, -2, 2))", "scale": 2, "label": "HighTemp", "type": "Numeric" } ] } }}. I haven't done that superbadge yet! How frustrating! I guess I am glad I am not the only one? Various trademarks held by their respective owners. "Awaiting a helpful response.Thanks,Mithilesh. Thanks in Advance (split in 2 for upload reasons){ "Load Temp Class Mapping": { "action": "edgemart", "parameters": { "alias": "Temperature_Classes_Mapping" } }, "Load Seed Bank": { "action": "edgemart", "parameters": { "alias": "seed_bank" } }, "Define Temp Range": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Load Seed Bank", "computedFields": [ { "type": "Numeric", "name": "lowTemp", "label": "lowTemp", "saqlExpression": "string_to_number(substr(Temperature,1,2))", "precision": 18, "scale": 6 }, { "type": "Numeric", "name": "highTemp", "label": "highTemp", "saqlExpression": "string_to_number(substr(Temperature,-2,2))", "precision": 18, "scale": 6 } ] } }, "Add Temp Class": { "action": "computeExpression", "parameters": { "mergeWithSource": true, "source": "Define Temp Range", "computedFields": [ { "type": "Text", "name": "TempClass", "label": "TempClass", "saqlExpression": "\"case \\nwhen lowTemp < 25 and highTemp < 25 then \\\"Polar\\\" \\nwhen lowTemp >= 25 and lowTemp <= 50 and highTemp >= 25 and highTemp <= 50 then \\\"Cool\\\"\\nwhen lowTemp >= 51 and lowTemp <= 85 and highTemp >= 51 and highTemp <= 85 then \\\"Continental\\\"\\nwhen lowTemp > 85 and highTemp > 85 then \\\"Tropical\\\"\\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 50) then \\\"Polar-Cool\\\" \\nwhen lowTemp < 25 and (highTemp >= 25 and highTemp <= 85) then \\\"Polar-Cool-Continental\\\" \\nwhen lowTemp < 25 and highTemp > 85 then \\\"Polar-Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and (highTemp >= 51 and highTemp <= 85) then \\\"Cool-Continental\\\" \\nwhen (lowTemp >= 25 and lowTemp <= 50) and highTemp >= 85 then \\\"Cool-Continental-Tropical\\\" \\nwhen (lowTemp >= 51 and lowTemp <= 85) and highTemp > 85 then \\\"Continental-Tropical\\\" \\nend\"" } ] } }, Second part:"CleanUp": { "action": "sliceDataset", "parameters": { "mode": "drop", "fields": [ { "name": "highTemp" }, { "name": "lowTemp" }, { "name": "TempClass" } ], "source": "Augment Temp Class" } }, "Create Seed Bank": { "action": "sfdcRegister", "parameters": { "source": "CleanUp", "alias": "seed_bank", "name": "Seed Bank" } }, "Augment Temp Class": { "action": "augment", "parameters": { "operation": "LookupSingleValue", "left": "Add Temp Class", "left_key": [ "TempClass" ], "relationship": "Climate", "right": "Load Temp Class Mapping", "right_key": [ "TempKey" ], "right_select": [ "TempClass" ] } }}, Following error:Challenge Not yet complete here's what's wrong:We can't validate the 'Create Seed Bank Agencies' node was created correctly.
Lido Jolly Catania Prezzi 2020,
Carl Buchan Political Party,
Jones Funeral Home Kankakee Obituaries,
Articles D