Skip to main content
Vorgestellte Gruppe

Reports & Dashboards

This is a public group. Ask questions, share posts and collaborate about reports & dashboards!
Diskutieren Sie diese Frage in Slack, um schneller Antworten und Hilfe in Echtzeit zu bekommen.

Since i started working at my current company in Salesforce - I wandered for far too long 'Why dont we have a 'leads' object and only 'Prospects' in sales cloud of salesforce (not MCAE).  

 

I recently found out that our Leads table was renamed to 'Prospects' about 5 years ago by an individual who no longer works for the company. They went into 'Rename Tabs and Labels' settings and did this which made the labels appear ootb showing 'Prospects' in Sales cloud wherever i was expecting to see 'Leads'.  

 

My question now - to clean things up so we can have a better structure of MCAE "Prospects" to "leads" to "Contacts" - i am planning to reset the rename of the Leads BACK to "Leads" and not "Prospects". I have done this in 2 of our sandboxes and everything seems to be pretty fluid and relatively quick depending on how much data you have.  

 

Could there would there be any API field name issues when thinking about integrations if i were to go in and rename the "leads" back to "LEADS"? 

 

Thanks!!! 

 

@Who owes me a beer?!? @Admin Group, Dallas, US @Trailblazer Community Cove @Salesforce.org System Administrators @* MC Account Engagement (fka Pardot) * @Reports & Dashboards 

3 Antworten
  1. 27. Okt., 20:49

    You're good to go unless something was terribly designed (integration or automation wise).   Standard practice shoudl be to refer to everything by API name vs the label.   The previous admin would not be able to rename a standard object API name. 

     

     

    Cheers!

Hi everyone,

I'm working at an organization with a large number of folders and reports accumulated over the years. I'm looking for an app that can visually display the folder hierarchy and allow me to easily move or delete reports. Doing this manually would take too much time.   

Does anyone know of a good solution or app for this?   

Thanks in advance!   

@Reports & Dashboards 

5 Antworten
4 Antworten
  1. Divya Chauhan Forum Ambassador
    17. Sept., 06:57

    Hi Rajiv, 

    Please check this first :  

    Make sure the Duplicate Rule is Active and is using the correct Matching Rule. 

    Verify that the record you created actually meets the criteria of the Matching Rule. 

    Confirm that Report is enabled on the Duplicate Rule. 

     

    I hope this help !!

 

Hi, 

I am looking to create a report to find all the accounts that have not had any visits in more than 6 months, 

Does anyone have any advice? 

Thanks

1 Antwort
  1. 16. Sept., 08:59

    Hi @Philippe Jublot

     

     You can try using an Accounts with or without Activities report to identify accounts that haven't had any visits (Events) in the last 6 months.

    Steps:

    1. Go to Reports → New Report.
    2. Select Accounts with or without Activities.
    3. Add a cross filter: Accounts without Activities.
    4. Add subfilters for the Activity Date, if available, to define the last 6 months.
    5. Filter the activity type to Event, if supported.
    6. Add Account Name, Owner, and other required fields.

    Important: Please verify the report results carefully. Filtering by activity date and event type is essential to avoid incorrectly including accounts that had recent visits.

    If the standard report doesn't support the required combination of filters, you may need a custom reporting approach or automation to identify accounts without Events during the last 6 months. 

     

    Hope this helps! 😊  

     

     If you find this response helpful, please mark it as the Accepted Answer, as it may also help other Trailblazers facing a similar issue. 

2 Antworten

Hi,  I need to create a specific report that should show:  The number of logins to the system in the last 30 days by users belonging to public groups, grouped by public groups.    For example:  User_1 is member of Group_1 and has logged in 10 times, User_2 is member of Group_1 and Group_2 and has logged in 5 times. In the report, I'd like to see:    Group_1:      User_1: 10      User_2: 5  Group_2:      User_2: 5    Getting this data is easy using SOQL, but I have no idea how to do it using reports.   Please help me ;)     @Reports & Dashboards 

3 Antworten

🎉 Big shoutout to our incredible Forum Ambassador, @Smitha Thomas for an awesome deep dive on "Make a Feild Avalible as a Dashboard Filter!📘 Check out the article here >> https://help.salesforce.com/s/articleView?id=005408536&type=1 

 

🔍 Found it helpful? Have thoughts to share?

 Let us know by clicking the "Yes" or "No"  button at the bottom of the article—your feedback helps us improve!🎉 Big shoutout to our incredible Forum Ambassador, for an awesome deep dive on> 🔍 Found it helpful?" style="display: block;" /> #Reports & Dashboards

 

 

I Have an analytics report  with 3 rows (Month, Quarter, Year), when I download it in excel, its as it should be but when i subscribe to it in analytics and it sends the excel there's an empty row under the header and  row 1 is in row 2, 2 in row 3 and row 3 is missing.  what's the issue here? i have no limit on the query   

@Reports & Dashboards 

1 Antwort
  1. 16. Aug., 07:48

    Hi Erick - the fact that a manual Excel export is clean but the subscribed one has a blank row under the header, everything shifted down one, and the last row dropped points squarely at the subscription's file generation, not your report or query. 

     

    A few things to check / try: 

     

    1. Groupings vs format: if this is a Summary report (grouped), the subscribed export often renders an extra structural/blank line that a plain export doesn't. Try a Tabular version of the same report (no groupings) as the subscription and see if the blank row and the shift disappear - that tells you the grouping rendering is the culprit. 

     

    2. Subscription row handling: subscribed/attached results have their own limits and formatting, separate from a manual export, so a blank row consuming a slot can push your last row (row 3) off the end. That matches the 'shifted down + last one missing' symptom exactly. 

     

    3. Confirm it's the platform: reproduce with a tiny 2-3 row report. If the blank-row-and-shift is consistent, this has the hallmarks of a known formatting quirk in subscribed report files rather than anything you configured - worth searching Salesforce Known Issues, and logging a case with the before/after files so Support can reproduce it. 

     

    Workarounds if you need clean output now: 

    - Subscribe at the Dashboard level instead of the report, or 

    - Use an Analytic Snapshot / a scheduled data export, which don't go through the same subscribed-report formatting. 

     

    If you can share whether the report is Tabular or Summary, and how the subscription is set up (attach results vs embedded), I can help narrow it down further. 

     

    Hope that helps track it down!

In our client on OKTA is enable so client don't want to use ' Require periodic step-up authentication when exporting or printing' feature because it required MFA for exporting reports, so please suggest me we can disable this feature or how we can bypass this feature other the IP restriction?

1 Antwort
  1. 3. Aug., 12:05

    Hi @Indramani Tiwari If Require periodic step-up authentication when exporting or printing is enabled, Salesforce does not provide a supported way to bypass it. You can disable the feature only if your organization's security policy allows it. If your client uses Okta for MFA, review your identity and session security settings to determine whether the feature is required. Otherwise, the only supported options are to disable the setting or use trusted network/IP exceptions where appropriate.

Hello, @Liz Skaates, a few months ago there was an alert (shown below) that stated Reports and Dashboards will no longer be available in Classic after March 31, 2027. Is that still the plan that reports and dashboards will cease to function (view/manage) in Classic as of April 1, 2027? Or is this timeline been postponed? Furthermore, is there a potential date to retire Classic altogether? Thank you so much!Classic Retirement for Reports and Dashboards

3 Antworten
  1. 30. Juli, 22:07

    Yes @Eric Burté, apologies for the duplicate post. However, I'm still trying to find a solid answer from Salesforce to ensure we're making decisions based on accurate deadlines. Cheers!