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 | |
Results tagged with saql
Search options not deleted
user 75669
SAQL - Salesforce Analytical Query Language
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 …
- 278
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 …
- 278
0
votes
How to find percentage using a single dataset
You receive the error, because you don't supply EA with information, where it should take 'converted' from. Do that by writing b.converted.
But still, there is a logical error in your query. Lets say …
- 278
0
votes
Accepted
Is it possible to group by a unique field but display a non-unique one with SAQL?
I just recreated your problem. It seems, that the graphs in Einstein Analytics just are not able to show multiple items for the same grouping.
So either you have to generate a unique grouping criteria …
- 278
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 …
- 278
2
votes
1
vote
Generate previous work day
I don't think there is a thing such as conditional filtering.
But you can create a query with "case when" and generate the value "3 days ago" or "1 days ago". Then insert that value in your main quer …
- 278
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. …
- 278
0
votes
Show derived measure in aggregate bar chart
In the top right corner, you can switch between Chart-, Table- and SAQL-Mode. You have to switch from Table to Chart and then choose the right chart Type. …
- 278
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 [...] …
- 278
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 …
- 278