Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 75669

TABLEAU CRM previously known as Wave or Einstein Analytics is Salesforce's cloud analytics tool which can be used with Salesforce Sales and Service cloud and other external and internal data sets.

0 votes

Combine/Concatenate Two Datasets

Where do you want to do that? Within the dasboard, then use the union command to combine the datasets. To create a new dataset, which then can be used in multiple dashboards/lenses create a dataflow a …
Patrick R.'s user avatar
0 votes

Get derived date dimension year or month

EA only generates these values for Dates loaded into a dataset: Einstein Analytics Dates To achieve someting similar, you can use the toString()-function: q = foreach q generate toString(newDate, "yy …
Patrick R.'s user avatar
1 vote

How to include a row with subtotals by second level group in Einstein Analytics using SAQL?

You'd have to create a second subquery such as: q2 = group q by Group2; q2 = foreach q2 generate "subtotals" as Group1, Group2, count() as A, sum(DataXY) as B; Afterwards union your …
Patrick R.'s user avatar
0 votes

Filter records not in other query results - SAQL

Bindings (or Interactions as they are called now) have a very strict syntax, and you don't get very good help on error correction, it usually just crashes. Anyway, here is the documentation: Bindings …
Patrick R.'s user avatar
0 votes
Accepted

Einstein Analytics difference of date and number

First, convert the now()-Date to epoch seconds, then substract the desired number of days (multiplied by 24 * 60 * 60 = 86400). Then convert this epoch seconds value back to a date. toDate(date_to_ep …
Patrick R.'s user avatar
0 votes

Meaning of (#) in Sum of # in Einstein Analytics

Since the latest release of Einstein Analytics Spring '20 in that window you see the label on the left and the technical name on the right. So # really is the columns Label, while Column1 is the techn …
Patrick R.'s user avatar
0 votes

Is it possible to create dynamic reference line in waterfall chart or Funnel chart in Einste...

Unfortunately it is not. I just tried to add a reference line manually in the json code. It doesn't crash or show an error, but it simply doesn't show a line.
Patrick R.'s user avatar
0 votes

OR Condition in JSON filter Wave analytics Dashboard

You can use the formula editor in the compare table, or write the SAQL itself. Both ways, you are going to use the coalesce function: coalesce(Code1__c, Code2__c) However there are still certain sit …
Patrick R.'s user avatar
0 votes

How to set current fiscal year as on load filter in Einstein Analytics?

You can simply add an Date Filter in Edit Mode. Then from the top right symbol with the three dots, select "Pick initial values" and set the Date Filter to "current Fiscal Year". Accept and save the d …
Patrick R.'s user avatar
0 votes
Accepted

Monday Morning Challenge: Join two data streams with SAQL in Salesforce Einstein Analytics

the 3 and 4 are missing, because you group by MaxMonth which is the same for both. (8 should however be there, it is in my test...) You have to use a little trick: Before cogrouping, you group query 1 …
Patrick R.'s user avatar
0 votes

Multiple SAQL queries in Apex cause You have uncommitted work pending

I have never called SAQL through Apex... However what jumps to my eye is the missing/wrong stream identifier in query3 out = foreach out generate qcall_date_Year [...] My guess is, that instead of q …
Patrick R.'s user avatar
0 votes

Einstein Analytics : Responsive Dashboard

Yes you can do that. Click on the widget in edit mode. Then on the right side select 'Query'. There you have to select single or multi selection as Selection Type. Also make sure "Broadcast selections …
Patrick R.'s user avatar
0 votes

Download analytics Lens, Datasets as Excel\CSV using Lightning component

You can embed Einstein Analytics Dashboards as described here: https://help.salesforce.com/articleView?id=bi_embed_lightning.htm&type=5 (I'm not sure whether lenses can be embedded, but you can just …
Patrick R.'s user avatar
2 votes
Accepted

Data merging in Analytics Dataflow

You have to use the augment node in the dataflow to do this. Choose Left Source, Left Key (it is written in singular, but you can use multiple keys), Right Source and Right Key. Then check all right f …
Patrick R.'s user avatar
0 votes
Accepted

Display current user's name in einstein analytics dashboard

That's actually not quite that hard. Create a new query (pick any dataset) with the following SAQL q = load \"MyDataset\"; q = group q by all; q = foreach q generate \"!{User.Name}\" as UserName; T …
Patrick R.'s user avatar

15 30 50 per page