Search Results
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 |
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 …
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 …
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 …
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 …
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 …
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 …
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.
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …