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.
376
questions
0
votes
0answers
17 views
saql create bar segments
I would like to create stacked bar based on something a saql query like this:
q = load "datasetname";
q = filter q by 'field1' == "false" and 'field2'=="homescreen";
q = filter q by date('...
0
votes
0answers
10 views
How to troubleshoot the connection error occurring while connecting data of AWS - RDS PostgreSQL with Salesforce in Einstein Analytics?
From Salesforce Einstein Analytics we are trying to connect the data through AWS-RDS PostgreSQL .
So, AWS-RDS, is in the client intranet network as well as we have integration in between this two ...
0
votes
0answers
6 views
Scheduling Einstein to pull a report from a Dashboard and Email it out
Title says it all, I want to schedule a report to pulled from a dashboard and then be emailed to a specific person. Does anyone know a way of doing this?
Possibly through flow builder?
0
votes
0answers
27 views
If I select a date how to get the time period between two dates (Start and end)
If I have two dates (Start and End) I want the values that are between the two dates once I select a date. For example if I choose a custom date then it should return the values that are between that ...
0
votes
0answers
8 views
Einstein Analytic - Display active filter in text widget
For a project I need to implement an active filter display for an analytic dashboard.
If I'm working on Opportunity dataset and the user filter by CloseDate_Month = 01 (january) and then select the ...
2
votes
2answers
55 views
+50
Einstein Vision issue when Creating the DataSet
I am trying to create a data-set using Einstein Vision API by following this trail. So i have successfully created the dataset by providing the following URL: https://developer.salesforce.com/files/...
0
votes
1answer
16 views
Permission Set Assignment in Salesforce Einstein Analytics Error
I created a Dataset in Einstein Analytics that simply gets data from Permission Set Assignment, nothing fancy.
While Running the Dataflow I am getting the below error:
Something went wrong while ...
0
votes
0answers
12 views
Einstein Dashboard Account Default
So I am trying to implement a dashboard for my sales account that has specific data based on which account the dashboard is inserted to. My problem is that I am not sure how to specify which data is ...
0
votes
0answers
22 views
Alias a GROUP BY column in an Einstein table?
I'm building an Einstein Dash with a data table that groups by a field on a related object (User record). It seems that I can't alias this column header because there is no Edit option on this column ...
0
votes
0answers
17 views
How exactly are the Einstein analystics external connectors secured?
I'm trying to connect einstein analytics to one of our local data servers. But network wont add the whitelist until they know how does this connection stay secure?
And luckily for me not a single ...
1
vote
0answers
24 views
calculate time difference between status changes for Order History
Scenario
We keep orders information into Salesforce and we have our own statuses too, whenever the order status changes in our Ecom system it updates that into Salesforce. I can get the timings via ...
0
votes
0answers
14 views
How to access Login History object from einstein analytics dataflow?
I have to create a report in Einstein Analytics where I can show the user's login details. For that I need to create a dataset using Dataflow and join User object with LoginHistory object in ...
1
vote
1answer
29 views
SAQL calculate average case close rate for einstein
Scenario
So I want to display average case closing rate(for now in minute) on dashboard.
What I've done
So if I'm not wrong I can calculate the difference time like
(closed date - created date)
...
0
votes
0answers
10 views
Einstein Dashboard: choosing (radar/metric) chart scales and polygon colours
I would like to do some simple (or so I thought) readability tweaks on a radar chart made on an Einstein Analytics dashboard.
For starters, I would like to be able to set the axes scales manually. I....
0
votes
0answers
19 views
Einstein Analytics - Limit dashboard results to only subset of dataset from the most recent day
I am creating a dashboard to display the most recent day's worth of data.
I have a sfdcDigest localized copy of a SFDC object that includes over a year's worth of records. I have a dataflow to create ...
0
votes
1answer
25 views
VRP using Einstein Analytics?
I wanted to know if we could use Einstein Analytics to solve vehicle routing problems. For example, how to minimize the cost of a trip, recommend ideal routes for pick-up and drop, maximize the ...
1
vote
0answers
33 views
Export Einstein Analytics Datasets
Is there a way to do an automatic export of records periodically from Analytics Datasets? I need to send the records to a Data Warehouse Server.
1
vote
0answers
19 views
Global variable using SAQL
Can global variables be used with SAQL? How can I see the value of the global variables in Wave Analytics?
2
votes
1answer
26 views
wave:selectionChanged behaviour in Summer '19
I'm creating a lightning app that interacts with an Einstein dashboard. The idea is that when a user filters data in the dashboard, a search is performed in an external system using the filtered data.
...
0
votes
0answers
27 views
cant Understand values inside SAQL Query?
I have a dashboard which was built using a template in one of its components. It was showing some wrong values. When I Explored it, I found this in SAQL query:
q = load "Account_Revenue5";
q = ...
0
votes
0answers
18 views
SAQL statement fill does not support Week in dateCols
Analytics SAQL Reference says it supports the week for dateCols in fill statement of SAQL, however it does not support weekfield.
Salesforce doc https://developer.salesforce.com/docs/atlas.en-us....
2
votes
0answers
33 views
Is it possible to save/persist data from an Einstein Dataset back to Salesforce?
We are building a Lightning application that will be used to show Einstein consolidated data to users.
We want to either consume this data directly from Einstein (we know we can do that with Wave SDK ...
0
votes
0answers
9 views
How to extract 'Connect to Data'(Analytics) from one salesforce org and deploy into another salesforce org
This question is regarding Einstein Analytics. I created a 'Connect to Data' and a Data Recipe in one salesforce org. This steps created the dataset in that org. Then, I extracted the Data Recipe from ...
2
votes
0answers
19 views
How to create an auto increment field in Einstein Analytics
I want to add to my dataset an autoincrement field but I don't know how to.
Is there any way to do this in the dataflow?
Thanks in advance.
0
votes
0answers
22 views
Bindings measures from two datasets in Einstein Analytics
I've got a problem. I'm trying to display the "%" in my number widget. It's easy with only one dataset but in my case I got two datasets. I want to take the budget value from Budget and sales value ...
0
votes
0answers
7 views
Deactivate Integrated User created by Einstein Activity Capture
I enabled Einsteini Activity Capture temporarily (for half a day) and decided I didn't want to use it. I deleted the configuration and turned it off. I just discovered that the Integrated User that ...
1
vote
0answers
26 views
Multiple filters for same field in wave:update
I'm developing a Salesforce Aura component that updates an existing Wave Analytics dashboard whenever something changes within the component.
Those changes may affect same field with several values ...
0
votes
0answers
9 views
Einstein Bot opens an external window not a popup
When I try to embed This code it works fine but in external window not as a popup in the page Could you help?
<body >
<h1>Cookbook Bot</h1>
`enter code here`<a id="...
1
vote
0answers
18 views
Custom (re)ordering and modification of legend in origami charts of Einstein Analytics
Custom (re)ordering of legend/bar segments in Einstein Analytics
Above is the current workaround solution for custom (re)ordering of legend bar segments in Einstein Analytics.
I've managed to attain ...
3
votes
2answers
57 views
Sharing of Accounts in Enterprise Territory Management
I struggle a bit with the ETM topic. I have set up ETM in SF and defined the dataflow to cover ETM sharing logic (with security predicate) in Analytics. However when I checked for a specific user I ...
1
vote
1answer
40 views
Can I send data to Salesforce Analytics / Einstein as JSON and not CSV?
The Salesforce Analytics / Einstein API documentation says that in order to upload actual data to the datasets you need to prepare CSV files and JSON is used only for metadata.
Is there any way to ...
0
votes
0answers
27 views
Exclude Measure from chart without columnmap
TL;DR: Is there anyway that I can control what lines/bars are shown on my chart and still use the static step (given that static steps require columnmap to be null)?
Bare with me while i explain what ...
1
vote
0answers
88 views
Embed Analytics Dashboard with Filter Logged In User
I want to embed a Lightning Analytics Dashboard and apply a filter to display a filtered set of records from my dataset in a dashboard. In this situation Case records, where filtered where Case's ...
0
votes
1answer
73 views
Analytics Facet issue - Syntax Error after token ) :: ilter q by (());
I have a SAQL step in my dashboard that goes something like this:
q = load "aDataset";
q = filter q by 'A__c' == "true" && !('B__c' >= "-");
q = filter q by 'Type__c' != "Organization";
...
0
votes
0answers
17 views
Match Date with range of Dates in Analytics Data Flow
I have a "Subscription" object in Salesforce that get two external keys CodeProduct and CodeDP (DP for Delivery Point). "Subscription" also has a range of date Start_Date and End_Date.
Now I want to ...
0
votes
2answers
106 views
Replace null values in JSON
I'm using a compare table and some values in my datasets doesn't exists. So when I'm trying to calculate the percentage between two rows I got no values. For example I got this image :
In the forst ...
0
votes
0answers
46 views
Get previous year date of today
I would like to compare the revenues from the previous and current year but not all the previous year. I want to compare until this date.
I have something like that :
q_A = filter q by date('...
1
vote
2answers
66 views
im trying to make a dashboard, but it is showing error, “Function doesn't have a type check definition”
"layouts": [],
"steps": {
"Amount_2": {
"type": "aggregateflex",
"query": {
"measures": [
"sum",
...
0
votes
1answer
22 views
Einstein to make sales predictions
I have a customer who wants to be able to predict how much each of their Accounts is going to buy in the upcoming months. They believe that the amounts are determined by a number of factors e.g. past ...
0
votes
1answer
100 views
How to schedule and export Dashboard from Einstein Analytic
Good day, All
Here I have question on the Einstein Dashboard usage, with the version we have, there is no schedule or auto trigger function on it, so user would get the Dashboard by access URL only. ...
0
votes
1answer
38 views
preconfigure filter affecting widget with disabled apply global filters
I have embedded a wave dashboard on a visualforce page.
In my dashboard I have charts that "Apply global filters is disabled".
What happen is when I view the dashboard on the visual force page, and ...
0
votes
0answers
33 views
Conditional message in Einstein bot
Is there a way I can just show some message based on some variable value.
I have tried to create a rule but in action I could not find message option.
I need to display different messages based on ...
0
votes
2answers
44 views
Einstein analytics. Update the template?
what steps i need to follow to add second dashboard in a template?
How to make changes in template-info.json to add dataflow/dataset ?
0
votes
1answer
33 views
Style for Einstein bot
How to change Color and style of Einstein chatbot in community?
I have tried with snippet setting file, but did not work.
0
votes
1answer
35 views
Bind the Result of one dataset to an another
I have two steps.
One with my Holidays group by years and month created with a single dataset with one column "Holidays" with all date of holidays in 2018 and 2019.
The second one is my Amount per ...
0
votes
1answer
77 views
Filter dataset by column from an another dataset
I want to filter my Date datasets by Holidays datasets with something like that :
a = load "Date_Test";
b = load "Holidays_Test";
b = foreach b generate 'Holidays' as 'Holidays';
a = filter a by '...
0
votes
0answers
17 views
Connect Einstein Analytics with Oracle BI tool
I need to connect Einstein analytics with Oracle BI tool. As we don't have any predefined connectors to serve this purpose, can anyone help me on this on what is the easiest way to do this.
0
votes
1answer
80 views
Filter Dataset with only Work Days
I would like to get the days from Monday to Friday (except holidays) in my SAQL queries. For now I only have Opportunity dataset with Amount and all rows related to CloseDate (Date, Year, Month, Day, ...
1
vote
1answer
127 views
Salesforce Analytics Dataflow - Aggregating datasets?
Assume I have a dataset like such:
Cart Data
----------
oId cId iId $$
1 C1 . 2
1 C1 . 3
1 C2 . 3
2 C1 . 1
3 C2 . 3
3 C3 . 4
4 c4 . 5
4 c4 . 5
5 c2 . 4
6 ...
0
votes
1answer
24 views
Get number of CloseDate_Day in a group of CloseDate_Month
I want to get the sum of Amount of the company per month (CloseDate_Month) and divide this sum by the number of CloseDate_Day in this month.
q = load "Test";
q = group q by 'CloseDate_Month';
q = ...
