EDGEANALYTIX, LLC
  • Home
  • SalesForce Solutions
  • Non-Profits
  • Analytics Lab
  • Testimonials
  • About
  • Home
  • SalesForce Solutions
  • Non-Profits
  • Analytics Lab
  • Testimonials
  • About

Analytics Lab:

A blog series distilling QUANTITATIVE data concepts AND USE-CASES IN THE EINSTEIN ANALYTICS PLATFORM.

Case statement in a compute expression to backfill null values or to effect binning.

3/18/2020

0 Comments

 
Here is a use case where null values are backfilled with 'unspec' or different texts depending on certain values of a field called timeUntil.Using a compute expression with a text type, enter the statement in the SAQL expression.
case
when 'Date_Time_Priority_Assigned__c'  is null then "Unspec"
when 'Time_Until_Prioritized_Days__c'  >0 and 'Time_Until_Prioritized_Days__c'  <=1  then "Prioritized w/in 24 Hrs."
when 'Time_Until_Prioritized_Days__c' >1 and  'Time_Until_Prioritized_Days__c'  <= 2
then  "Prioritized within 48 Hrs."
when 'Time_Until_Prioritized_Days__c' >2
then  "Prioritized after 48 Hrs."  
else "Unspec" end


0 Comments



Leave a Reply.

    Author

    Write something about yourself. No need to be fancy, just an overview.

    Archives

    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    March 2020
    January 2020
    December 2019
    November 2019

    Categories

    All

    RSS Feed

Site powered by Weebly. Managed by Hostwinds