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.

Filter by
Sorted by
Tagged with
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 = ...