Feed

Hi! I was using this formula that was validated: 

IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 3000, 4, IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 6666.66, 3, IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 16666.66, 2, 1))) 

I recently needed to update the parameters and now I'm getting the Incorrect number of parameters error. What am I doing wrong? 

IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 2999.92, 5, IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 6666.58, 4, IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 16666.58, 3, IF(Solution_Tracker__c.Contracted_MRR__c:SUM < 49,999.92, 2, 1)))) 

Does anyone know if it’s possible to calculate the Agent’s Average Response Time, Customer’s Average Response Time, Total Handling Time, and Abandonment Time for the new chatbot in a report?

Previously, we used Chat Transcripts, which already had these fields available, making it easy to include them in reports.

Now, with the Messaging Sessions object, these fields are not available by default. Even after creating a Messaging Sessions with Messaging Session Metrics report type, I still can’t retrieve this information directly.

I found this documentation: 

 🔗 

Messaging Session Metrics – Salesforce

It mentions that the MessagingSessionMetricType field provides these metrics, but when I add this field to the report, it only displays the metric type, not the actual value. 

Is there any way to extract these values? Maybe using a formula or another approach? 

#Reports & Dashboards  @Reports & Dashboards

We are trying to implement salesforce scheduler and in experience cloud we are not able to see the timeslots availability for the service resource.    We are able to see the slots internally or debugging the flow. We gave access to all the neccessary obect using sharing settings to the guest profile.     

Hi!  Hoping someone can help. This is a strange one to me.   

First step, I created a formula/lookup field on the Account object (to be able to pull data onto the Account from a Standard object related to the Account).  Then I created a second formula field on the Account to pull data from that Standard object.  After creating the formula field it seems the same % value is being captured for all accounts in my report.  When I did a spot check - they should not all be the same. I can't wrap my head around why its only capturing the one percentage across all accounts.  Any help would be greatly appreciated!    

Here is the screen shot of the report - and from the actually account record- it should reflect 80% on my report.    

The Standard Object I am pulling the data from...

The new formula field I created...all say 60%

#Data Management  #Sales Cloud  #Reports & Dashboards

Hi, even after creating the classes properly, I'm still getting the below error in the challenge. Anyone can help me to get rid of this issue? 

Challenge not yet complete in <My Playground>

Executing the method 'getAccount' from the Apex class 'AccountManager' failed. Either the service isn't configured with the correct urlMapping, is not global, does not have the proper method name or does not return the requested account and all of its contacts. 

Hi, 

I'm getting the following error message when I try to complete the challenge for Control Access to Fields? 

We can't find that the ‘Manage Job Applications’ permission set grants read and edit object permissions for Job Application 

Error: We've hit a snag.

Please contact support or visit our status page for more information.

The help documents I'm able to locate say to enable web-2-case and that should solve the problem. Web-2-case was already enabled. Any idea on how I can activate cases on the experience cloud site? 

Hello.. I'm struggling with the datatable element trying to put something other than '{records}'. 

I have a JSON that has two nodes (rough example below), one with returned permissions (for controlling actions on the flexcard called "perms") and a second node that has the list of records I want to display in the table, "recordList".. What is the syntax/value I need to put in the 'Records' field on the datatable properties to select "recordList" to display in the table? I've tried things like {records.recordList}  

{record.recordList} 

[record][recordList] 

[recordList]...

{ "perms":{   "perm1":true,   "perm2":false  }, "recordList":[  {   "field1":"value",   "field2":"value"  },  {   "field1":"value",   "field2":"value"  } ]}

I have a rule for users to populate field's before closing off an opp but I would like this to only be for type new business     its working but it dosnt exclude the other values. Can someone help expain what I am doing wrong       ISCHANGED( StageName ) && OR( ISPICKVAL( Type, "New Business" ) && Stage_Number__c >= 2 , ISPICKVAL( StageName, "Closed Won" )) 

&& 

OR( ISPICKVAL( Pricing_Matrix__c , "" ) , 

    Account_Close_Fields_Reviewed__c = FALSE , 

    ISPICKVAL( Pricing_Matrix__c , "Old Pricing" ) && ISPICKVAL( Contract_Type__c , "Committed" ) && Amount = 0 , 

    ISPICKVAL( Pricing_Matrix__c , "Old Pricing" ) && ISPICKVAL( Contract_Type__c , "" ) , 

    ISBLANK( Contract_Start_Date__c ) , 

    OR( ISPICKVAL( Contract_Type__c , "Committed" ) , ISPICKVAL( Pricing_Matrix__c , "New Pricing (from Q4-2024)" )) && ISBLANK( Contract_End_Date__c ) , 

    ISPICKVAL( Pricing_Matrix__c , "Old Pricing" ) && ISBLANK( Annual_Minimum_Spend__c ) , 

    ISBLANK( Billing_Contact__c ) , 

    ISPICKVAL( Bill_to_different_Tenant_ID__c , "" ) , 

    ISPICKVAL( Bill_to_different_Tenant_ID__c , "Yes" ) && ISBLANK( Bill_to_Tenant_ID__c ) , 

    ISPICKVAL( Pricing_Matrix__c , "Old Pricing" ) && Standard_ID_price__c + Original_ID_Price__c + Lite_Price__c + SoF_Price__c + IAV_Price__c + IDV_Price__c + Set_up_Fee__c + Integration_Support_Fee__c + Maintenance_Fee__c = 0 , 

    ISBLANK( Closed_Won_story__c )

)   

@Formulas - Help, Tips and Tricks