* CRM Analytics (fka Tableau CRM) *

I have two separate question, both about dates. 

1. Date Formats - It appears if my date format is not one of the supported ones there is nothing I can do in a recipe by just providing the format.  Every way I tried failed.  I eventually broke the date into it's components and built a valid date string to convert.  This seems very cumbersome.  Any one solve this problem in a simpler way?  What I'd really like to do is just provide the format in the dataset json, but once again unsupported formats seem to fail rows in the load.
2. Formatting Date Labels in Charts - I know I can do this with SAQL but I want to be able to provide a way a less sophisticated user could define a format, e.g. 12/1/2025 instead of 2025-12-01.  I swear I had a trick for this a while back but I couldn't rediscover as much as I tried.  I thought I had a way to do it in the same way you build up a text in a text widget.  Couldn't find it again...

#Tableau CRM #CRM Analytics  #Analytics #

Can Salesforce External Connectors be used to sync CRMA datasets from another org or just Salesforce objects?  If we can connect datasets, can you please provide instructions?

I am Getting below Error When I am running the dataflow in Analytics Studio. 

Something went wrong while executing the ApexCallout1 node: Error in GetEdgemartCurrentData for edgemart ApexCallout1 [error category: USER]: No edgemarts found with specified URL:esObject/edgemart?current=true&alias=ApexCallout1 (02K8V000000zO2bUAE_03CKj000006EHqPMAW_000) 

Is their any way we can resolve the error like we can update the dataflow and re run or any other way. 

Due to this I am not able to sync the data...please help me to resolve the error.. 

Thanks, and Regards 

Pranav Shah 

Why can't I update two fields in Salesforce CRM using a recipe in Analytics if I have Field-Level Security set to Visible?   

@* CRM Analytics (fka Tableau CRM) * 

We are experiencing issues when running recipes in environments that have more than one data sync connection configured.

Specifically, we have two apps with distinct connections:

• Safety Analytics uses the SFDC LOCAL connection.
• WMD uses SFDC LOCAL for WMD.

Both connections sync the same object (User), but with different field selections:

• The WMD connection syncs 2 fields from the User object.
• The Safety connection syncs 3 fields (2 same as WMD, plus 1 additional).

The issue arises when:

1. The WMD sync runs last, updating the shared metadata for the User object.
2. Then, the Safety recipe is executed, resulting in an error because the additional field expected by the Safety recipe is no longer present (as per the last sync by WMD).

This conflict is affecting recipe reliability and is blocking our data workflows. How to manage multiple connections syncing the same object with different field selections, and how to avoid these overwrite issues in data recipes. 

Thank you in advance. 

Department is the uncommon field of User object between the 2 local connections

Hi All, feel dumb even asking this question...But while I am in a Tile/Lens of an Analytics Dashboard, is there a way to turn off the automatic update so that I can remove more then one filter or column at a time without it doing a preview update? It's obviously doable within Lightning with the "Update Preview Automatically" toggle that lives within each individual Report...But I cannot find this feature anywhere within CRM Analytics at the Dashboard or Lens level

Hi all,  

This question is based on a use case of creating a query of average GPA in CRM Analytics.  If I have a dataset where I want to get the average GPA of students, but in that dataset have varying rows for each student as the dataset also includes event attendance details for each student.  

EX:  

Student 1, GPA 2.2, Event on 1/22/2024  

Student 1, GPA 2.2, Event on 1/26/2024  

Student 1, GPA 2.2, Event on 3/16/2024  

Student 1, GPA 2.2, Event on 3/18/2024  

Student 2, GPA 4.0, Event on 2/12/2024  

The average I would hope for is 3.1 which accounts for each student only once (2.2 + 4.0)/2  

However, due to the multiple rows for student 1, the GPA I get is 2.56 ((2.2+2.2+2.2+2.2+4)/5) which inadvertently lowers the average GPA.  Any suggestions? Thank you in advance. 

My current example query displays as follows which gives the GPA of   

q = load "Example Data"; 

q = group q by all; 

q = foreach q generate avg(q.'GPA') as 'A'; 

q = limit q 2000;

Hi Team,

I’ve generated two result sets using SAQL, as shown in the attached screenshot. I'm now trying to achieve a combined or transformed output based on these results.

I attempted to use cogroup, but I wasn’t able to produce the desired outcome.

Could you please assist with the appropriate SAQL logic to achieve this?

Thank you—your help is greatly appreciated.

@Prabhat Mishra

The first screenshot shows how the graph looks like if value isn't sorted. As you can see, it was sorted alphabetically based from Month Name then Segment.  The second screenshot shows how the graph looks like if it's sorted by record count however the Month Name is repetitive.  

My question is, is it possible to sort the value based on record count in descending order within the group without repeating the value on first group (month name)?  

.   

CRMA dashboard , I want to display a trend chart (e.g., a mini line chart showing revenue or usage over time) as a column in a Table widget, where each row shows the trend for a specific Account

. 

Any guidance, or examples would be much appreciated!