Analytics & Data Science

Hi guys,  

i need your help.  

In Analytics studio i add a fomula columns with this formula: 

case  

when '

RefOrder.Name

' == "Alessandro Marcioni" && sum(Netto_ADV__c)>= 650000 then 1500 

when '

RefOrder.Name

' == "Antonio Amendola" && sum(Netto_ADV__c) >= 300000 then 1500 

when '

RefOrder.Name

' == "Christian Morico" && sum(Netto_ADV__c) >= 830000 then 1500 

when '

RefOrder.Name

' == "Daniele Tinelli" && sum(Netto_ADV__c) >= 400000 then 2000 

when '

RefOrder.Name

' == "Fulvio Caccialupi" && sum(Netto_ADV__c) >= 520000 then 1500 

when '

RefOrder.Name

' == "Ilaria Bruno" && sum(Netto_ADV__c) >= 560000 then 1500 

when '

RefOrder.Name

' == "Marco Franco Selvi" && sum(Netto_ADV__c) >= 600000 then 1500 

when '

RefOrder.Name

' == "Rosario Loddo" && sum(Netto_ADV__c) >= 580000 then 1500 

when '

RefOrder.Name

' == "Sergio Staiti" && sum(Netto_ADV__c) >= 750000 then 1500 

when '

RefOrder.Name

' == "Walter D'alessandro" && sum(Netto_ADV__c) >= 650000 then 1500 

else 0  

end  

i need to add to this formula a filter how i can do this in a formula column in analytics studio? 

Thanks in advance 

Best 

Hey All ,

I am looking to filter user records to only one specific profile name or licensed by in dataflow filter node with SAQL filter check . Here is the screenshot .

"Something went wrong while executing the filter user node: Invalid Filter Expression=Licensed_By__c : EQ : CEC [error category: USER]: Syntax Error at position [line 1: column 17] after token Unexpected character ':' :: ;censed_By__c : EQ : CEC; (02Kj0000000Kys4EAC_03C7i000001vT5TEAU)"

Please help me out if there is anything i need to change or use other filter expression. 

Hello, 

How can I update my sales analytics dashboard to include the new opportunity stage 'Contractor Awarded'? The new stage has been added to the opportunity stage object but hasn't updated in the sales analytics. How can I update this in the recipe to reflect on my sales analytics dashboard?

I am trying to use Case function in Compute Expression to bucket Staff Role field values in to Clinical and non clinical type . but for some reason it show me this error after running dataflow . 

Something went wrong while executing the Adding Bucket Fields node: invalid field expression for field 'Clinical_NonClinical' [error category: USER]: Syntax Error at position [line 2: column 5] after token when :: ;Case ;when 'Staff_Role__; (02Kj0000000Kys4EAC_03C5b0000058PisEAE)

Reference screenshot of field : 

Syntax of Case function : 

Case 

when 'Staff_Role__c' == "A1A Clinical" then "Clinical staff"

when 'Staff_Role__c' == "A1A Commercial Manager" then "Non-Clinical staff"

when 'Staff_Role__c' == "A1A Commercial Staff" then "Non-Clinical staff"

when 'Staff_Role__c' == "Buy Up Commercial Manager" then "Non-Clinical staff"

when 'Staff_Role__c' == "Buy Up Commercial Staff" then "Clinical staff"

else "other" 

end 

please help me if you find any error in function syntax or something missing 

Presented by David Martin, Darshna Sharma

Sign Up 🎟️

Here's an excellent opportunity for you to learn the art of Timeseries forecasts from a senior Data Scientist of salesforce. In this session, David will walk us through:

1. What does time series forecast even mean? And why are we calling it forecast, and not prediction?

2. Data you need to run good timeseries forecasts

3. Holtwinter algorithm

4. How to read and understand the final results

5. Quick demo of timeseires in CRMA using saql and data prep

You do not need to be an expert in statics or mathematics or python to attend this session. A basic understanding of 'mean' and 'normal distribution of data' is good enough :)

I encourage you to join this session regardless of whether you work on CRM Analytics. David has some excellent, easy-to-grasp information to share. Towards the end, we'll see how easy it is to do timeseries forecast using CRM Analytics.

**About CRM Analytics Learning Days**This exclusive webinar series covers a range of topics on CRM Analytics, including Einstein Discovery. Join us for deep dives into common use cases, questions, and best practices from product experts that will inspire and guide great analytics implementations for you to get the most out of the platform.

Category: Artificial Intelligence

Release: Spring ’23

Level: Basic

#Olympus @Rikke Hovgaard, @Geoff Rothman