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 53513

Analytics refers to anything that can be done with reports and dashboards. There is a REST-based Analytics API and an Apex Analytics API.

1 vote
1 answer
2k views

SAQL: How to group by string field on whether it is NULL or NOT NULL

As mentioned in the subject I need to group a string field's data by whether its empty or not empty. How can I do this with SAQL? Do I need to create a boolean variable? and group by that?
Sanjan's user avatar
  • 23
1 vote

SAQL: How to group by string field on whether it is NULL or NOT NULL

Managed to figure it out q = load "mydataset"; q = foreach q generate (case when 'MyField' is null then "no_case" else "got_case" end) as 'Status', count() as 'C'; q = group q by ('Status'); q = fore …
Sanjan's user avatar
  • 23