Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Jhili PatraJhili Patra 
Superbadge Einstein Analytics Data Specialist Step 3 Error: We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct.

User-added image
Best Answer chosen by Jayson (salesforce.com) 
Divya ChoudharyDivya Choudhary
Sure , Ankush

Here is the JSON:
{
  "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": "Filter Agency Records"
    }
  },
  "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"
    }
  },
  "Load Agency Detail": {
    "action": "edgemart",
    "parameters": {
      "alias": "Agency_Detail"
    }
  },
  "ID Agency Records": {
    "action": "computeExpression",
    "parameters": {
      "source": "Add Agency Fields",
      "mergeWithSource": true,
      "computedFields": [
        {
          "defaultValue": "FALSE",
          "name": "IsAgency",
          "saqlExpression": "case when Phone is not null then \"TRUE\" else \"FALSE\" end\n",
          "label": "IsAgency",
          "type": "Text"
        }
      ]
    }
  }
}


And here is Dashborad snapshotUser-added image
 
Dan PaulDan Paul 
I can't really see anything special about this user.  I'm using the Log In functionality on the user page.  Some users with the same exact profile/role/permission sets are a able to get into Analytics Studio.  The full error is:
"This page has an error. You might just need to refresh it. Aura.loadComponent(): Failed to initialize application. ui.insights.components.wavePage.WaveModel.appConfig: system.security.IllegalSessionException"

A refresh does nothing, same error.  They have the "Einstein Analytics Platform User" permission set and "Analytics Platform" permission set license.  
Best Answer chosen by Dan Paul
Dan PaulDan Paul
It appears to be related to using the proxy login (the login button on the user record).  We needed to set the user up with Einstein permission set then have them log in directly and access Einstein.  Then we could use the proxy login going forward.
Kelvid PangKelvid Pang 
Hi, 
I am following one of the trailhead module: Extract Salesforce Data into Analytics. I have successfully link the oppportunity, account and user in the data manager. But the schedule was failed. Would like to seek advise on how to troubleshoot/debug this?User-added image
Best Answer chosen by Kelvid Pang
vaibhav raghavvaibhav raghav
Hi Kelvid,

I find the solution for the problem, you have to do Full sync of all opportunities from the connect as shown in the picture.

User-added image 

Once you are able sync all the opportunities, then you again run the Default Salesflow Dataflow. 

User-added image

and it will show status successful under the Job 

User-added image
Katie GuthrieKatie Guthrie 
The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values. The dataflow was completed, but the LookupSingleValue node didn't augment any columns. Either the node didn't find any matches, or a join key contains only null values. Data Sync isn’t scheduled for the SFDC_Local connection used in this job. Your data is only as up to date as the last manual sync. Schedule Data Sync from the Connect tab to make sure the job has the latest data.

What can I do to fix this ASAP? Any help would be amazingUser-added image
Best Answer chosen by Katie Guthrie
Deep SinghDeep Singh
Thanks, Katie. Can you mark this answer as best answer :-)

Thanks!
Gabriele CianciGabriele Cianci 
Hello everyone,
I'm new user of Einstein Analytics and I'm tryin g to complete Einstein Analytics Data Preparation Specialist challenges.
The third challenge ask me to 'Create Seed Bank Agencies'. I did it but this error appears:
"Challenge Not yet complete... here's what's wrong:
We can't validate the 'Create Seed Bank Agencies' node was created correctly. Check the required fields, field types, node name, and alias are correct."

I tried to restart challenge, to use another dev org, to follow the same procedure of other users but this error always appears.
Anyonw knows a solution?

Thank you
Best Answer chosen by Gabriele Cianci
Ankush AgarwalAnkush Agarwal
Hi Gabriele,

You may refer below link for solution of this issue:

https://trailblazers.salesforce.com/answers?id=9063A000000lixE


Issue is with the Agency Detail.txt file. While Importing the file please change the Longtitude and Latitude to to "Dimension".
Delete the file from existingf dataflow and perform Edgemart again to import the same file. Update your dataflow and run it. It will get Pass.
Barb DowneyBarb Downey 
We have a large dataset in Einstein that is sourced with a CSV. Every month we have been replacing the data with a new csv that included the current month. (This file is 5 years of data). My question is this.... what are the pros and cons of using a Salesforce custom object as a source of the dataset rather than using a large csv everytime? 

It has been a nightmare because the data comes out of our backend DB and needs manual clean up every time.If we could use our custom object it would be so much easier to maintain.
Best Answer chosen by Barb Downey
Akchhat MehrotraAkchhat Mehrotra

There is no problem in storing a data in custom object.
You can schedule a weekly or daily refresh as well. If you are not making changes in old data then Incremental refresh will be good but if data is changing then you can set it to Perodic full refresh.

Nivedita ShuklaNivedita Shukla 
I want to have similar data with Einstein Dataflow .Currently I have done join with table and getting below table value
Current Table:
Field Type  targetId  confidence
F1            t1        30
F1            t1        90
F1            t1          50  
F1            t1        10  
F2            t1          10
F2            t1          20
F2            t1          70
F2            t1          40    

we want only top3 based on confidence descending and based on field type and targetId

Field Type  targetId  confidence
F1            t1        90
F1            t1        50
F1            t1          30  
F2            t1          70
F2            t1          40
F2            t1          20

Any help would be appriciated.

Thanks!
Best Answer chosen by Nivedita Shukla
Nivedita ShuklaNivedita Shukla
Hi Andrew, Why I need in data label because of row limitation in einstein analytics dashboard. Since we will have 15 records per cases due to einstein recommendation and it would be problem going ahead. So wanted to get confidence field so that i can show them as multivalue . Thanks, Nivedita
Deborah OrthDeborah Orth 
I'm getting an error on the Trailhead Project "Build Advanced Einstein Analytics Dashboards", step 3, Engage Users with Animated Pages.  The error reads: Error: Faraday::ClientError. Message: 550: To retrieve a lens with aggregateflex type containing query values, you need API version 46 or higher

I've got a brand new DE Analytics org and have succesfully completed Step 1 & 2, (after a few issues that resulted in errors as well, but it finally got past) but this one I can't seem to get to validate.

I've also confirmed the org API is 47.0.  Having read a few other Trailhead Analytic issue postings I went into Settings and enabled all the Analytic setting but that didn't fix the validation error.

Any help would be greatly appreciated!
Best Answer chosen by Bhavin (salesforce.com) 
Caryl WangCaryl Wang
Same error happened to me, what i did is to redo the table widget - make sure you only have two columns - "Opportuntiy" and "Sum of Amount". I had the values table instead of compare table and had that error. Hope this helps. 
michele tancorramichele tancorra 
Hi all,
I have a dashboard that is based on a dataset (A).
I want to change dataset A with dataset B (this datasaet have the same fields but different values).
Is possible to change dataset without change the entire dashboard? (es. modifing the JSON of the dashboard)

tks
Best Answer chosen by michele tancorra
Akshay AhujaAkshay Ahuja
Hello Michele,

Yes. You can change the dataset reference in the dashboard JSON. Here are the steps:

1. Open the new dataset as a lens. Press Ctrl + E on Windows (or Cmd + E on Mac). This will open the JSON code for that lens. Go to the bottom and copy the dataset definition. Looks something like this:

User-added image

2. Go to the dashboard and open it in JSON mode (Press Ctrl + E on Windows or Cmd + E on Mac). Go to the bottom section and replace the dataset definition. Basically remove definition for dataset A and add daatset definition for B.

3. Search for the reference of dataset A in all the steps. You can do a Ctrl + F and serach for dataset A. Replace each one of them with Dataset B. If it a step in compact form, then the dataset definition will be in above form (as shown in screenshot). If the step is is in SAQL form, then you just have to replace the name of the dataset in the load statement.

4. Click Done. If done correctly, the dashboard would reference the new dataset.

Before doing this, make sure that all the field names in both datasets are same.

Hope this helps. Thank you.

Best Regards,
Akshay
Lauren AntzLauren Antz 
If I clone an Einstein Analytics dashboard and change one of the underlying queries in the clone, will the queries of the original dashboard be modified?
Best Answer chosen by Lauren Antz
Prabhat SharmaPrabhat Sharma
Hi Lauren,

No, it won't. The clone function always creates a new component. Hence, no issue in changing SAQL.