Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [saql]

SAQL - Salesforce Analytical Query Language

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

How to bucket field values in Einstein analytics

I have a dataset with a field as Order Country. It has field values as 'AUS', 'USA', 'GBR', 'IND', 'KEN', etc. Now, is there any way to bucket these values as bucket 1: 'AUS', 'USA', 'GBR' - Total ...
0
votes
0answers
14 views

In Einstein Analytics Dataflow, how to calculate first, second and last entry of a partition (compute relative)

I have a list of Orders. I need to calculate the most recent, the second most recent and the oldest Order for each Account. In Einstein Analytics I use the field "Compute Relative": I created the ...
1
vote
2answers
2k views

SAQL Using Current year and doing calculations with dates in a Formula Condition

I want to do calculations with dates and use 'current year' in a formula condition. When I tried to manipulate dates in a formula I always receive an error of incompatibles types; NUMBER AND DATE. ...
1
vote
0answers
25 views

Is it possible to group by a unique field but display a non-unique one with SAQL?

I'm a SAQL beginner and I'm currently trying to modify an errant dashboard in Einstein Analytics that I did not create. The dashboard contains a step that currently groups by Account Name and sums the ...
0
votes
1answer
575 views

Wave Einstein Analytics filter relative dates in dataflow with filter node

I need to filter opportunities in my dataflow that have a date 'last month' to 'end of current year'. I cannot use filters in the sfdcDigest node as I am doing a couple of calculations later that need ...
1
vote
1answer
623 views

Change Time Zone in Wave Dashboard

I am using page 28 of this doc for reference: https://resources.docs.salesforce.com/200/latest/en-us/sfdc/pdf/bi_dev_guide_saql.pdf I need to change the time zone in the step. I am trying to use the ...
0
votes
0answers
40 views

Generate previous work day

I want to display sales from yesterday but the company is close Saturday and Sunday. So when the day is Monday I need to return Friday sales. But if the day is Tuesday I can return Monday sales. Is ...
3
votes
1answer
1k views

How to find percentage using a single dataset

I am working on SAQL to find Percentage of Leads that has been converted into opportunities. I am working on wave-utils to check my SAQL and I am receiving the following error: Cogroup projection ...
1
vote
0answers
256 views

Einstein Analytics Binding statement for Year to Date where date is listselector

I have a list selection for Production Date (Year--Month for ease of selection). I have a number that is the credits that should be filtered year to date based on the selected Production Date. I ...
2
votes
1answer
225 views

Faceting Not Working Within Dataset - Einstein Analytics

I am editing a dashboard in Einstein Analytics. It contained 5 charts, all from the same datasource, and they all faceted between one another when selections were made. I was asked to change the top ...
0
votes
0answers
38 views

Formatting a derived measure that was calculated from multiple datasets

I understand how to format a derived measure using the XMD. But here, my derived measure comes from multiple datasets. Here is my SAQL: q = load "Dataset1"; q = group q by all; q = foreach q ...
0
votes
1answer
392 views

Concatenation of fields and text in Compact filter

I have this statement in SAQL q = foreach q generate Region, TerritoryRMA, ContactSysId, PurposeTopic, HasActivityFlag, 'Territory'+\"~~~\"+'Flag' as TFlag; q = filter q by TFlag in {{selection(...
0
votes
0answers
23 views

Salesforce Einstein Dataflow Join

In the dataflow, Is it possible to merge two tables based on the same key in which one table has multiple values? (See attached image) Site Code is the key between the two tables.
0
votes
1answer
52 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
4answers
3k views
0
votes
0answers
18 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 ...
0
votes
1answer
569 views

Conditional Highlighting for Widget in Einstein Analytics

Is it possible to create a conditional highlight in Einstein Analytics I have this following query: q = load "Santher2_new"; result = group q by 'categoria'; result = foreach result generate q.'...
0
votes
1answer
463 views

“No results found” data type for Wave

I'm trying to do some basic error handling in SAQL. We have a binding that gives as a result "No result found" both in the SAQL editor and in the actual step. I'm trying to capture the data type of ...
0
votes
1answer
453 views

Group is not a dimension 'Field__c'

Hello I have the following problem, in Analytics I try to group my data set for a specific field and it does not allow it, I get an error Group is not a dimension 'Field__c' What is this error? ...
0
votes
0answers
31 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
2answers
522 views

Incompatible types: STRING and NUMERIC

I'm attempting to change the dates on some data within Wave Analytics to get the correct time zone showing, but I'm getting the error "Incompatible types: STRING and NUMERIC" whenever I attempt the ...
0
votes
1answer
578 views

SAQL- How to group by AccountID and report the first value in a table?

I am currently looking to de-duplicate data in a dataset. Reason being, I need to group together all accounts reporting on a criteria, so we may then sum and total the values of each account to get an ...
1
vote
0answers
36 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
46 views

How to display values for two picked dates in Analytics (SAQL)

I have to let the user pick two dates and view a number of events for these dates. I can easily make it for a fixed time interval, like this: q = load "dataset"; q_A = filter q by date('date_Year', ...
1
vote
1answer
83 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
63 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 ...
1
vote
0answers
37 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?
0
votes
0answers
25 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....
1
vote
0answers
78 views

SAQL Date format conversion

I am pulling in a date field from a secondary (Japan) SFDC org into our native org. The format in the Japan org shows it as just a date (yyyy-MM-dd) but when I look at the date in the data connection ...
2
votes
0answers
42 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
48 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
1answer
124 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
2answers
377 views

How to convert decimal to percentage in saql?

How to convert decimal to percentage in saql?
0
votes
2answers
172 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
1answer
153 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
1answer
60 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
106 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
1answer
152 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 '...
1
vote
1answer
323 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
154 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
votes
1answer
99 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
1answer
26 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
1answer
144 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
409 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 ...
0
votes
0answers
33 views

Dynamic Filter in APEX SDK Query

In below query inside filter if i specify the direct value it works fine, ConnectApi.LiteralJson result = Wave.QueryBuilder.load('0Fb0v0000000vtbCAA', '0Fc0v000001QGWOCA4') .filter('Field == \"...
0
votes
0answers
105 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
1answer
84 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
94 views

Wave Analytics JSON Filter SAQL

I have a problem when editing a SAQL in wave. When I edited SAQL and update the chart the curreny symbol and comma is remove. Is there a way to add the currency and the comma. What I already did is ...
0
votes
0answers
54 views

Do Einstien Analytics Support Long text area field filter

I have a saql which is filtered using Long Text Area. When I remove the field the query is working fine but when it is included, it is throwing this error Query Exception is failing Please find ...
0
votes
0answers
30 views

Co-group fields from three objects in Wave Analytics

I have three objects viz., qACC , qCON and qOLC. Now from these three objects, I have different fields as follows qACC- 'Country', 'Year','Month'; qCON- 'Country__c','PROC_YR','PROC_MO'; qOLC- '...