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.
1
vote
0answers
8 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
11 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
15 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
5 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
12 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 ...
2
votes
2answers
31 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 ...
0
votes
1answer
17 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
12 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
39 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
33 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
13 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
63 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
39 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('...
0
votes
2answers
35 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
19 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
31 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
20 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
10 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
1answer
24 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
15 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
23 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
37 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
8 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
48 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
62 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
19 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 = ...
0
votes
0answers
9 views
Strange error while save 'Enable Data Sync and Connections'
Got a strange error when enable the 'Enable Data Sync and Connections' first time in the Analytics->Settings. But in the second time I can able to save it in the Analytics enabled Dev Org. Is it a ...
5
votes
1answer
100 views
Wave/Einstein Analytics & React App Communication
My gut instinct is to use Analytics SDK, but a cursory glance doesn't reveal it.
Is it possible for Analytics Dashboards to embed Lightning Components, iFrames, or Connected Apps, or conversely for ...
0
votes
0answers
8 views
Calculated column in Einstein tab based on groupings
I have an Einstein compare table with groupings and resulting columns-
Parent Account
Salesperson
Account
a Sum of a child revenue object
then a MAX of a field on the parent Account.
I want to do ...
0
votes
0answers
16 views
How to add second dashboard which uses diffrent datadflow (data is from salesforce org) to a template through a workbench?
I have created a template, it shows only ui.json & variables.json. template-info.json, folder.json is not shown . But the template created with one dataset & one dashboard. How to add the ...
0
votes
0answers
104 views
Einstein Analytics - SAQL - Compute expression in Dataflow - Period over Period formula
I have a formula field I need to create in Data flow using a Compute expression.
It needs to group by our 'Record_ID' and compare this weeks data to last weeks.
The data i want to compare is labeled ...
1
vote
1answer
39 views
Einstein Analytics
I'm working on managed package where it is deployed to many users. We are now adding new Einstein Analytics Templates and dashboard in the managed packages. If end user don't have analytics enabled or ...
0
votes
0answers
17 views
Update Template in einstein analytics
I create an app in my org with 1 dashboard & one dataset. I also create Template with this which works good.
Now I add Second dashboard & second dataset. Now I dont understand how to update ...
-1
votes
1answer
37 views
SAQL to find the remaining days in the year?
I want to found the count of days remaining in the year in SAQL .
q= foreach q generate daysbetween(toDate(date_to_epoch(year_start_day))-now()) as 'daysRemaining'
I want apply formula 365-now() in ...
0
votes
0answers
28 views
Filter Data Based On Values Matching In Two Columns
Is it possible to filter data based on values in two columns matching in Einstein Analytics? For example, I have one column named BO Qty and another named Supply Qty. If BO Qty is 1 and Supply Qty is ...
0
votes
0answers
11 views
Analytics - Way to limit return on a table
I have a table on a dashboard in Analytics that returns account information based on another custom object.
The relationship is the following:
Account > Opportunity > Custom Object > Custom Object ...
0
votes
0answers
24 views
Einstein Scoring for Custom Object
We want to have Einstein Scoring for our custom Job object. And we would like it to be like Lead Scoring on the screenshot:
We plan to develop a custom Lightning Component for that purpose.
I ...
0
votes
0answers
53 views
Global Filter einstein analytics
I created an einstien analytics dashboard last year and so far everything is working fine. I created a new dataset using one of the dataflow and created a step using this new dataset and updated one ...
0
votes
0answers
9 views
How to get the mapping between 'Group' Object and The object where the Einstein analytics dashboard information stored
I have developed some Einstein Analytics Dashboard and shared those dashboards among Public groups. Now I want to view the information 'Which dashboard are shared among which public groups' to prepare ...
0
votes
0answers
37 views
How to pass SAQL to lightning component through VF Page?
I have a custom action which calls the VF page from the Lens(Einstein analytics) .
In the VF Page i have a controller also am calling the lightning component . In the controller side am getting the ...
0
votes
0answers
19 views
Open window in same tab after the custom action from dashboard in Einstein Analytics
I have created a Dashboard with table contains Account Records. I have added the custom action "Account Update"in the lens to call my VF Page .It is opened in the new tab.
Can i open the page in same ...
0
votes
0answers
13 views
Opportunity with Tasks in Einstein
I'm trying to create a simple analytic in Einstein - Opportunities with or without Tasks. I've even tried to create an analytic just for Tasks. The data flow runs and finds over 100k records, but ...
0
votes
1answer
47 views
Einstein Analytics data binding to boolean value
I am trying to conditionally hide tabs based on the output of a certain table. Currently I am attempting to set the navigationHidden property of the page to false like so:
"navigationHidden": "{{cell(...
0
votes
0answers
17 views
How to have Certain Bots Appear Based on a Users Region/IP Address?
I want two different bots to appear based on an end user's region/IP address. For example, if someone was in the UK, I'd have my UK Bot interact with the person. However, if someone was in the US and ...
0
votes
1answer
33 views
Wave Analytics Filter by Formula field
Is it possible to filter the rows based on the formula fields. I created a table
and I only need to show rows that is not in <=-25% && >= 25%.
0
votes
0answers
26 views
Einstien Analytics Dashboard error: Aggregate query must have measures
I have a requirement where the old dashboards(created earlier to 2017) should be converted to new dashboards.
Now when I click on "New Dashboard Designer" from old dashboard edit page, I will get a ...
1
vote
1answer
75 views
Einstein Split in Journey Builder Error
I am trying to use Journey Builder to apply an Einstein Persona Split to my Journey Builder audience. This is a recurring email campaign that has been set up to be started from a triggered Automation. ...
0
votes
1answer
42 views
SAQL to generate a field not in a group by statement
I'm a bit of a beginner to SAQL. I have been tasked with maintaining a fairly elaborate dashboard and data flow and have been asked to add some features to it. There is a lens that displays a chart ...
0
votes
0answers
39 views
Einstein Analytics Dataflow Field Missing Digest
I am working to build a new Dataflow in Einstine Analytics.
I want to build a digest to extract data from a Custom Object's Custom Field, with type Lookup(Account).
When I go to create the digest-...
