Skip to main content
Argomenti#Analytics

#Analytics42 utenti parlano di questo argomento

Fai una domanda...
Shravani Muthe (Na presso Na)
11 ago, 12:58
CRM Analytics currency conversion behaving differently for custom objects.

Hi everyone,    Iā€™m stuck on a currency conversion issue in Salesforce CRM Analytics and could use some help debugging it.    I have a custom Salesforce object with a Total Price field of type Currency. The records also have different CurrencyIsoCode values.    When I bring this object into CRM Analytics, CRMA automatically converts the Total Price values into our organizationā€™s currency, which is EUR.    The problem is that the converted values have a lot of variance compared to what I expect.    My assumption is that CRMA should be using the latest exchange rates from either the DatedConversionRate object or the CurrencyType object, depending on how the currency conversion is configured.    What makes this confusing is that I also have the standard Opportunity object in CRMA. The currency conversion there looks correct and is much closer to the expected values.    So Iā€™m trying to understand:    How exactly does CRM Analytics perform currency conversion for custom objects?    Which exchange rate does it use ā€” CurrencyType, DatedConversionRate, or something else?    Does the behavior differ between standard objects like Opportunity and custom objects?    Is there anything specific I need to configure in the dataset/recipe to make sure the correct exchange rate is being applied?    What would be the best way to debug where the incorrect conversion is happening?    Iā€™ve already compared the original Total Price, CurrencyIsoCode, and the expected exchange rates, but Iā€™m still unable to figure out why the custom object conversion is so different from Opportunity.    Any pointers on where to look would be really helpful!   

 

@* CRM Analytics (fka Tableau CRM) * 

1 risposta
Scrivi una risposta...
0/9000
Patricia Pegus (Business Analyst presso Launchpad) ha postato in Salesforce Business Analysts
11 ago, 01:59

Hi everyone ā€” reaching out to this community as I explore my next role.

Iā€™m a CBAP-certified Business Analyst with 20+ years of experience across federal government, FinTech, and SaaS, and I also hold Salesforce Business Analyst and SAFe Agile certifications. My background includes Salesforce flows and SOQL, data mapping, UAT leadership, and compliance documentation, with growing hands-on experience in AI and automation tooling.

Iā€™m open to Senior BA, Product Analyst, BA/PM Hybrid, and Product Owner roles. If you know of anything open, or are hiring, Iā€™d love to connect ā€” happy to share my background in more detail.

Thanks for reading, and good luck with your own searches too.

#Integration #Trailhead #Analytics #Automation
1 commento
Scrivi un commento...
0/9000
Jing Chen (Business Analyst presso Savant Systems) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
22 lug, 14:15
Is it possible to split a string and duplicate other columns in Recipe or Dataflow?

Hi All, I would like to achieve the screenshot transformation of a dataset in Recipe or dataflow . Is it possible? 

Screenshot 2026-07-22 at 9.54.02ā€ÆAM.png
7 risposte
  1. Jing Chen (Savant Systems)
    7 ago, 20:38

    Thank you. Yeah I went back to my SF developer and said I can't do this in Analytics. He will build the Bug-Case relation for me in SF. 

Scrivi una risposta...
0/9000
Randall King (Sr Analytics Manager presso Cellular Sales) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
22 mag 2025, 15:41
CRMA End of Life?

I saw this in the Ohana Slack Group. Is there any truth to this, I certainly hope not? 

 

 

CRMA End of Life?

 

 

20 risposte
  1. Roman Michalik (salesforce.com Germany GmbH)
    22 mag 2025, 17:01

    Salesforce has not and is not considering to set CRM Analytics to End-of-Life.

    Yes, there are rumors in the market - they are simply wrong.

Scrivi una risposta...
0/9000
Valerie Zivich (Data Analyst presso Sequoia Financial Group) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
4 ago, 19:57
Dataflow: How to create a date field - 6 months prior

Hello, 

I'm currently trying to create a date field in a dataflow to calculate the month end date 6 months prior to another field. For example: 

 

Existing_Date_Field

= 2026-06-30 

Desired_Result

= 2025-12-31 

 

I'm struggling to find a combination of functions that gets me this result. Has anyone tried to do something similar and could you share your SAQL expression?  

 

 

Thanks!

8 risposte
  1. Valerie Zivich (Sequoia Financial Group)
    5 ago, 20:40

    Posting a solution incase anyone is trying to solve the same issue in the future. It may not be the most simplified solution, but it does give the correct results: 

     

    month_last_day(toDate(
    (case
    when string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "MM")) <= 6
    then number_to_string(string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "yyyy")) - 1, "0000")
    else number_to_string(string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "yyyy")), "0000")
    end)
    + "-" +
    (case
    when string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "MM")) <= 6
    then number_to_string(string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "MM")) + 6, "00")
    else number_to_string(string_to_number(date_to_string(toDate(Existing_Date_Field_sec_epoch), "MM")) - 6, "00")
    end)
    + "-" + "01",
    "yyyy-MM-dd"))
Scrivi una risposta...
0/9000
Michael Adzovic ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
27 lug, 17:39
"A Recipe Must Specify a Dataflow" Change Set Error

Hi, everyone-- 

 

We are trying to move some CRMA assets from our DEV to our TEST environments and we are getting the following error

A Recipe Must Specify a Dataflow. 

 

 

Does anyone know what this error means?  We are completely perplexed (and frustrated) because our recipes are independent of dataflows and we want to be able to move our CRMA assets between environments via change sets. 

 

Any guidance or experience would be greatly appreicated.  

5 risposte
  1. Ramakanth Mandarapu (Cognizant)
    28 lug, 11:28

    @Michael Adzovic - Click on View/Add Dependancies , there you should be able to see the same recipe name with type as Wave Dataflow or Analytics Dataflow.

Scrivi una risposta...
0/9000
Harshit Sahu (Salesforces Developer presso IBM) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
23 lug, 11:19
CRM Analytics ā€“ Best Chart to Visualise Case Lifecycle Across Overlapping Phases

 Hi Salesforce Community,  

 

I am working on a CRM Analytics dashboard to visualise the lifecycle of cases across 6 defined phases based on asset delivery and warranty dates.  

 

BACKGROUND: We have cases linked to assets.  

Each asset has: -  

A Delivery Date -  

A Warranty Start Date -  

A Warranty End Date  

We have defined 6 phases based on when a case was created relative to these dates:  

Phase 1 ā€“ Cases created before Delivery Date  

Phase 2 ā€“ Cases created before Delivery Date but still open at Delivery Date  

Phase 3 ā€“ Cases created between Delivery Date and Warranty Start Date  

Phase 4 ā€“ Cases created before Warranty Start Date but still open at Warranty Start Date  

Phase 5 ā€“ Cases created between Warranty Start Date and Warranty End Date  

Phase 6 ā€“ Cases created during warranty period but still open after Warranty End Date THE  

 

CHALLENGE: The phases are designed to show the flow of unresolved cases from one phase to the next:  

- A case created in Phase 1 that remains unresolved at delivery also appears in Phase 2  

- A case created in Phase 3 that remains unresolved at warranty start also appears in Phase 4  

- A case created in Phase 5 that remains unresolved at warranty end also appears in Phase 6  

 

This means one case can legitimately belong to TWO phases  

 

-it is not a data quality issue, it is by design.  

 

WHAT WE WANT TO SHOW:  

 We want to visualise:  

1. How many cases were created in each phase  

2. How many of those cases were handed over (still open) to the next phase  

3. The relationship between paired phases (1ā†’2, 3ā†’4, 5ā†’6)  

 

QUESTIONS: 1. Is there a recommended chart type in CRM Analytics that can show this kind of phase flow or handover between stages? 

I really wanted to use Funnel chart in my case i have to use different formulas. and in because one case case be in phase 1 and Phase 2.

   

 2. Would a Sankey chart or waterfall chart be possible in CRM Analytics? or better chart can be used??

2 risposte
  1. Roman Michalik (salesforce.com Germany GmbH)
    27 lug, 08:14

    I'd use a sankey chart to show the flow between stages. The main challenge will be to calculate the status of the cases at creation time and at the current time to define the two (different) phases per case.

Scrivi una risposta...
0/9000
Darren Bullough (Senior Finance Systems Analyst presso Taylor Rose Limited) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
22 mag, 08:26
Financial Modelling in CRM A

Hi, 

 

I'm looking to build Financial Models in CRMA - just wondering if anyone has done this? ...I'm particularly interested in how to go about creating a corkscrew and if there's a way to do that without using tons of unrelated number widgets. 

 

Example corkscrew - Carried Forward = Previous month's Brought Forward, Opening Brought Forward is a number (from a query), subsequent month's b/f = the sum of that month's c/f and movement.

Financial Modelling in CRM A

 

Can this be done with a table or would I need to build a custom LWC?

4 risposte
Scrivi una risposta...
0/9000
AARTHYSHA SARAVANAN (CRM Analytics Developer presso IBM) ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
17 lug, 15:57
Dynamically set page in link widget / Text widget interaction

Hi! I have a use case where I need to dynamically set destination page in a link widget based on logged in user. Wanted to check if its possible to achieve this with either pages within same dashboard or through components?

4 risposte
  1. Roman Michalik (salesforce.com Germany GmbH)
    21 lug, 15:39

    +1 with @Ada Xu

    : I'm not aware of a way to make the link destination dynamic, because it doesn't support bindings. Same with text widget and interactions. 

    Show and hide of widgets is not available in CRM Analytics (yet).

Scrivi una risposta...
0/9000
Vishnu Vardhan Nandyala ha fatto una domanda in * CRM Analytics (fka Tableau CRM) *
15 lug, 15:51
Display Dashboard Widget in an external Site

Hello Everyone, 

 

We started exploring CRM Analytics since few months, I was wondering if there are any ways I can display these dashboard widgets/Dashboard on an external site?

1 risposta
  1. Sai Rahul Mummidi (Brillio LLC)
    16 lug, 09:58

    @Vishnu Vardhan Nandyala

      Yes, you can absolutely embed CRM Analytics (formerly Einstein Analytics/Tableau CRM) dashboards and widgets into external sites. Salesforce provides a few different avenues to achieve this, depending on where the site is hosted and who your audience is.  

     

    i. Third Party Web Apps (Non Salesforce Sites) 

     

    ii. Salesforce Experience Cloud (External Portals) 

     

Scrivi una risposta...
0/9000