Questions tagged [einstein-analytics]
Wave (new name Einstein Analytics) is Salesforce's cloud analytics tool which can be used with Salesforce Sales and Service cloud and other external data sets.
448
questions
0
votes
0answers
12 views
Parse JSON in the TextArea field using Salesforce Analytics
I have a Custom object that is created via LWC.
One of the fields on that object is a 131072 textarea that contains a serialized array of Ids (e.g. Account Ids), like so: ["001ABCSDXXX",&...
2
votes
0answers
18 views
Possible to pull the code from analytics studio by using sfdx [closed]
I have created Dataflow, recipes and stories in analytics studio, now i need to pull the code and need to store all code in Local.. It possible to pull the code in sfdx(vs code).
Can you please help ...
0
votes
0answers
15 views
How can I set a global variable dynamically in an Einstein Analytics Dashboard
I am trying to set the view as filter to default to the current user. Here is the code I am using:
This is the filter:
{
"dataset": {
"id": "...
0
votes
0answers
37 views
Unable to deploy analytics studio in sfdx
I have created a dashboard and dataset in scratch org. and I need to pull the code of analytics studio in sfdx with Vscode.. But unable to pull the code. There is any possible any to pull code in sfdx....
0
votes
0answers
10 views
How to know when a <wave:waveDashboard> loads completely in Aura
I have a <wave:waveDashboard> in a custom aura component. My component is
<aura:component implements="flexipage:availableForAllPageTypes, flexipage:availableForRecordHome" access=&...
0
votes
0answers
13 views
Using lens in Discovery Story
I know this isnt possible, but is there anyway that we can use transformed lens to an Einstein Discovery Story.
We have some complex calculations that are built using formula in lens and we want the ...
0
votes
0answers
7 views
Total grouped by columns and rows Einstein Analytics Pivot Table
I have a pivot table with three fields on Opportunity table. Account Industry, Opportunity Stage and Amount. Now I need to group the Amount i.e. show the total amount based on Industry as well as ...
0
votes
0answers
5 views
Why the Einstein analytic background flashes white and then aqua
When loading an einstein chart, the background flashes white, then aqua. Then the actual chart loads.
Why it happens?
Any fix there?
Thanks
0
votes
1answer
38 views
Einstein dataflow sync node error
I am trying to create a data set for Campaign object in our sandbox but get an error on Sync
Campaign (Replication) when the dataflow runs:
Something went wrong while executing the Sync_Campaign node: ...
0
votes
0answers
14 views
I am trying to run this saql query for date conversion
q = load "DTC_Opportunity_SAMPLE";
q = foreach q generate 'Close_Date','Close_Date_Year','Close_Date_Month','Close_Date_Day',
toDate('Close_Date', "yyyy-MM-dd") as Cdt;
0
votes
0answers
50 views
Static Step Binding in Einstein Analytics
I have a requirement to show results by quarter, month and week on select on toggle options. This toggle is a static step with values as "Quarter", "Month" and "Week".
...
0
votes
0answers
19 views
Einstein Analytics dashboard picklist value is not showing
we have a dashboard with 3 datasets, but in the dashboard while choosing a picklist value we are not able to see the 4th value, all recordtypes have access to that field. What could be the other ...
0
votes
0answers
10 views
Unable to create a dataset from EInstein Analytics Studio
in Einstein Analytics Studio, I dont'have to "Dataset" option in the create button
Do you know why?
Do I need to buy more licenses of something?
Regards
0
votes
0answers
12 views
Einstein Prediction is not re-calculating
I want to predict that Opportunity will be won or lost. I created a model where i have set the "Yes" and "No" Example Set. My model is working well. When I create/update the ...
0
votes
0answers
16 views
Einstein Chatbot advanced Analytics
I'm working on a big Einstein Chatbot project at the moment and I noticed that there isn't really much Analytics provided by Salesforce itself about the Users in the Chatbot, apart from all the basic ...
0
votes
1answer
26 views
Tableau CRM: How to add dynamic “date” via computeExpression?
in my dataflow I have a computeExpression that should add a "Date" field.
That date field should always contain the first of the current month (e.g. for right now: Feb. 1st 2021).
I've tried ...
1
vote
0answers
18 views
When a WaveDataFlow is scheduled - where the information is stored? Which metadata type is referred to view
We have a job scheduled WaveDataFlow to run every 2hours in our Production org. And some user has modified the scheduled job to run every 24hrs instead of 2h.
We have verified the AuditTrailSetup but ...
1
vote
0answers
5 views
Wave API: How do i download image of Analytics lens widget
From UI, I am able to download widget image as png, csv or excel. I just want to know if we can do the same using REST API?
0
votes
1answer
58 views
How to calculate date difference using two separate data rows?
I'm using the LiveChatTranscriptEvent object to try and determine the time difference between the events ChatRequest and TransferredToQueue. Each Type is a different row on the object so it would ...
0
votes
0answers
55 views
Pass ID from URl to filter condition in Wave Dashboard lightning component
I have a Lightning APP page , where we embed Wave/Einstein dashboard using wave:waveDashboard lightning component. I need to set filter condition where I need to use the ID from the URL of the ...
0
votes
0answers
95 views
Einstein Analytics Data Preparation CSV symbols error
in my prep for the SF Einstein certification I've been working on the "Einstein Analytics Data Preparation Specialist" super badge.
I'm on step 3 and I'm getting the following error:
I've ...
0
votes
0answers
14 views
Filter Einstein Analytics Dashboard using attribute value
I am trying to embed Wave/einstein dashboard in a lightning page using Aura Component. When I am trying to add it in a record page through configuration , I am able add the filter condition using the ...
0
votes
1answer
37 views
Combine/Concatenate Two Datasets
I would like to combine/concatenate two datasets that don't have any key/field relationship. Attached to this post are the example and the result format. Is this possible? If yes, how can this be done?...
0
votes
2answers
64 views
MALFORMED_QUERY: ;Id > '0X8000000000000' ORDER BY Id ASC LIMIT 1 OFFSET 249999
I am trying to synch the ListViewEvent object to Einstein Analytics, but when I do I get the following error
I am selecting, only few fields, so I don't understand why my sync object isn't working, ...
1
vote
0answers
20 views
Help needed with SAQL fill()
I need your help with the fill() SAQL function.
I have created the query below and it runs, but the fill() doesn't work (no zeros get inserted). Please let me know what I am doing wrong here. Thank ...
0
votes
0answers
14 views
Augment based on Dates
I have a date field on QuoteLine Qbject. Need to augment it with existing dataset(D1) in EA(Einstein Analytics) on the basis of Product code and dates lying in between the start date and end date of ...
0
votes
0answers
38 views
Global Filters from dynamic selection
I've created a SAQL query that uses {{ cell(MyQuery.results,0,"ColumnName").asString() }} to create a dynamic filter and it works perfectly with my Pillbox selection.
The question that I ...
0
votes
0answers
13 views
Weekly Per FTE calculation only shows 1 bar in Chart, SAQL
I am trying to calculate the number of logs per FTE per week to show in a graph with a bar for each week. The logs and the FTE are in 2 separate datasets so I am using cogroup to bring them together. ...
1
vote
0answers
20 views
SAQL: How to count yes/no responses to chatbot question
I've been using Salesforce for less than two months and EA less than one.
Requirement: I need to create a report that answers the question, "What is the client feedback on the chatbot?"
Data:...
1
vote
1answer
36 views
Wave:SelectionChanged event is not firing
I tried a lot but I don't know what I am missing to capture wave:SelectionChanged event.
Used same code as available on : https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_sdk.meta/...
0
votes
0answers
98 views
Salesforce Einstein Analytics - Grouping and Navigation in Einstein Dashboard Lightning Home page
I have above DataSet, want to build 2 dashboards from the dataset. The dashboard should show the data based on the logged in user(tried the filter in lightning home page but dynamic filter is not ...
0
votes
0answers
29 views
Convert a Formula in Report to a column in an Analytics Dataset
I'm very new to Analytics Studio and could use some guidance. I have this Dataflow so far
The goal is to add a column to Ryan_Test dataset here that replicates functionality we have in a Report (see ...
0
votes
0answers
26 views
Access parents and grand parents related records in Einstein Analytics
There is a "Contract Price" object related to Account Object. Account's parent is identified by "ParentId" field on Account. I need to show data from parent as well as grand parent ...
0
votes
1answer
21 views
Dynamic SAQL Wave Analytics
I'm trying to use IN operator in my SAQL dynamically while doing callout using rest API.
If I'm trying to use hardcoded in operator it’s working.
Working:
q = filter q by 'Category' in ["...
2
votes
0answers
158 views
Einstein Activity Capture download email from AWS
In Einstein Activity Capture, email is "captured" and stored in AWS, not Salesforce. Is there any way to get the email from AWS into Salesforce? For example using Analytics REST API or ...
0
votes
0answers
72 views
How to add Image in Einstein Analytics Table for each row
I am new to Einstein Analytics probably one week old.
I want to add image in a column for each row. Suppose I have a column called FeedbackLink(which is basically formula field having image in ...
0
votes
0answers
72 views
Creating a basic Lightning App that will display an Einstein Analytics Dashboard using Lightning Out
I'm trying to create a basic Lightning App that will display a Dashboard from Einstein Analytics.
Here's the code that I'm using.
CMP
<aura:component access="global" >
<wave:...
1
vote
0answers
158 views
Einstein Analytics: Cannot delete “Queries with Errors” in Dashboard
I am designing a dashboard using Einstein Analytics. The dashboard has come very far with change in multiple dataset widget. So, before retrieving the dashboard using sfdx, I was cleaning up unused ...
0
votes
1answer
55 views
Using SAQL to place total at bottom of results instead of alphabetically ordered
I have a SAQL Query which takes a list and attempts to display a total row at the bottom.
However, the way that my code is written is causing the Total column to be alphabetically rearranged so that ...
0
votes
0answers
19 views
Einstein Analytics - define and use a custom fiscal period
I know you can define a custom fiscal year, but is there a way to define a custom month and week within Salesforce? For example, I want August to start on August 5th and end on September 5th, ...
2
votes
0answers
23 views
Einstein Analytics : retrieve datasets via API
I've been trying to retrieve lens and that lens corresponds to a dataset using wave API ( reference : https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_rest.meta/bi_dev_guide_rest/...
0
votes
0answers
42 views
Analytics Activities Dashboard
We just recently enabled the Einstein Activity Capture and Activity Metrics. And found that we could use the Activities Dashboard from the Einstein Analytics. I assigned the permission set for myself ...
0
votes
0answers
211 views
Einstein Analytics relative dates for filtering
Does anyone know how to access the salesforce fields CloseDate_Year, CloseDate_Month, and CloseDate_Day in the EA dataflow for filtering. I need to filter the opportunityHistory dataset using a ...
0
votes
0answers
37 views
IGO_Products Updated Uuid
I'm having trouble updating the Uuid filed in our IGO_Products data extension.
The first time I uploaded a Product Catalog I mapped the wrong field to the 'Product Code' (mapped it with product type). ...
0
votes
1answer
50 views
Is it possible to save dataflow exports to Salesforce records?
I have built a connection between NetSuite and Salesforce using the Data Manager from Analytics Studio. I have a column of data from NetSuite I would like to save (ideally automatically) to a ...
0
votes
0answers
110 views
`ConversationDefinitionEventLog.EventLabel` cannot be grouped in SOQL or via Einstein Analytics - always returns `0`
I'm trying to do what should be a relatively simple dashboard for our Einstein Bot, we just want to figure out what the most popular dialogs are. I've found the data and it is stored in ...
0
votes
0answers
15 views
Unable to Update the format of the images used in Einstein Analytics Template
I generated a Template for analytics app using Vs Code and Salesforce CLI,after that I found out that somehow the images that were used in that analytics app were in "svg" format which is ...
1
vote
0answers
115 views
Einstein Analytics on External objects [closed]
Can Salesforce Einstein Analytics be sourced on External objects and external data source
0
votes
1answer
323 views
How to include a row with subtotals by second level group in Einstein Analytics using SAQL?
I would like to add a subtotal row at the bottom of a compare table in an Einstein Analytics dashboard. The table is made up of sums of measures grouped by two dimensions. The subtotals needed are ...
0
votes
1answer
71 views
Get derived date dimension year or month
I'm creating a derived date dimension in SAQL and wanted to find out if there was any way to get the year or month (or day or quarter) parts from it? Normally, adding an "_year" to the end ...
