Skip to main content

#Reports & Dashboards97 utenti parlano di questo argomento

Hi all! 

I want to create a report that is a list of Person Accounts and pull in a field from a related record - Donor Giving Summary.  

So, I choose 'Accounts with Donor Giving Summary' 

I then want to filter this list with a cross filter of only people associated to a Campaign. Once I do this, I lose all results. 

My research says this is bc the Person Account's

Contact

is associated to the Campaign, not the Account. 

SO....what to do?  

I tried to create a new report type of Account & Contact & Donor Gift Summary but DGS is not directly associated to Contact.   

What is the advice here? (YAY Person Accounts.... :/)  

#Nonprofit Cloud #Reports & Dashboards

5 risposte
  1. 28 set, 23:26

    Thanks everyone, we have a fair few 'Deluxe' report already, but not sure I will be able to achieve my goal above using lookup fields & values.

0/9000

I have split records into respective Service Territories: I want to be able to see a count per Service Territory using the same criteria, excluding two filter conditions: is this possible? Record count required illustrated by red below and criteria I need removing highlighted: Report record query: is it possible to create a linked record count from a smaller filtered list?

 

 

image.png

 

 

 

#Reports & Dashboards  #Reporting  #Reports  #Salesforce Admin

0/9000

I created a report on a standard report type to fetch lead data. My filters are Show Me = All Leads, Created Date = Last 30 Days, and Lead Source = Broker. The report returns 40 records, but when I query the records with the same filters, it returns 45. I also created a report on a custom report type, and it returns 45 records. 

In my custom report type, I am using only one object, Lead. However, in the standard report type, multiple objects are used: User, Owner, Role, Lead, Account, and Contact. Does this affect the data being fetched?  

 

End User =  System Administrator 

 

#Salesforce Developer  #Salesforce Admin  #Reports & Dashboards

1 risposta
  1. 28 set, 11:28

    Hi @Rupesh Mohare

     

     

    Yes, the Report Type can affect the record count. It’s not simply because the standard report type contains multiple objects; the relationships and ā€œwith/withoutā€ settings defined in the report type can determine which Lead records are included. 

    I would compare the standard and custom report types, especially their object relationships, standard filters, and filter logic. Also ensure the report and SOQL are running with the same user/access context. 

    So, the 40 vs. 45 difference is likely related to the report type’s record scope/relationships, rather than SOQL returning incorrect data.  

     

    https://help.salesforce.com/s/articleView?id=analytics.reports_report_type_reference.htm&type=5&utm_source

     

     

    Hope This Helps!!

0/9000
Lena Wong ha fatto una domanda in #Trailhead Challenges

Hi everyone,

I would appreciate some architectural guidance on a Salesforce security requirement.

We need to restrict Sales users from exporting or extracting company-wide financial/reporting data, while they must continue using Salesforce normally, including the Salesforce Mobile App.

Our initial approach was to remove the API Enabled

permission from their corresponding Permission Set Group to prevent API-based extraction tools such as Data Loader or spreadsheet connectors. 

Howeever, I would like to confirm with you, if API Enabled is also required for the Salesforce Mobile App, which Sales users need to use.

Therefore, my questions are:

  1. Is removing API Enabled an appropriate approach for preventing data extraction in this scenario, or would this have unintended consequences beyond the intended restriction?
  2. What would be the recommended Salesforce architecture to restrict API-based data extraction for Inside Sales while keeping access to the Salesforce Mobile App?
  3. Would API Access Control / Connected App allowlisting be a better approach, for example allowing Salesforce Mobile while restricting other API clients?
  4. Are there other Salesforce permissions or security controls that should be considered specifically for preventing report/data export without disabling API access entirely?

The business requirement is specifically to restrict data extraction

, not to prevent Sales users from using Salesforce Mobile or other approved Salesforce functionality. 

 

The focus is on:

  • Reports: No creating, editing, cloning, or exporting.
  • Dashboards: No access to restricted Turnover dashboards.
  • Subscriptions: Prevent receiving Reports/Dashboards via email.
  • List Views: Prevent export/print as an extraction method.
  • Folder Sharing: Prevent indirect access to restricted Reports/Dashboards.

Any guidance or documentation from Salesforce would be greatly appreciated. 

 

@Salesforce Administrators & Developers, @Salesforce Administrators and Developers, @APAC Architects, @Data Quality & Management

 

 

#Trailhead Challenges  #Trailhead  #Salesforce Developer  #Salesforce Admin  #Reports & Dashboards

1 risposta
  1. 25 set, 17:08

    Hi Lena, 

    Yes, removing API Enabled would impact the Salesforce Mobile App, since the mobile app requires API access. So I wouldn’t use that permission alone as the control for this requirement.  

     

    A better approach is to keep API access for the users who need Salesforce Mobile and use API Access Control to restrict API access to only approved/allowlisted connected apps. Salesforce supports this model specifically for limiting API access while allowing approved apps.  

     

    For report extraction, also control the Export Reports permission separately. Removing that permission prevents users from exporting report data, while folder sharing and report/dashboard permissions can be used to restrict access to sensitive content. 

    I’d therefore treat this as multiple layers: API Access Control + Report/Folder permissions + Export Reports + subscription/access controls, rather than disabling API access entirely. 

0/9000
Lena Wong ha fatto una domanda in #Trailhead Challenges

Hi everyone,

I need some architectural advice on the best way to handle report and data access for a global team without turning role management into a maintenance nightmare.

 

  • We have report folders separated by countries: Country A Reports, Country B Reports, and Country C Reports.
  • In our Role Hierarchy, we have local roles at the bottom (e.g., Sales Rep Country A, Sales Rep Country B) and a high-level corporate role at the top called Global Management.

The Business Requirement:

 

Product manager users in their Country or Regional Level role complained not being able to access reports with data related to other countries, so we moved them to the

Global Management team for them to be able to see everything

. They require full visibility to access records (Accounts, Opportunities) globally, but they also need to open and view the reports inside the local folders of Country A, Country B, and Country C. 

 

The challenge:

 

We noticed that when we move a user from a local country role up to the

Global Management

role to give them global record visibility, they immediately lose access to some of the regional reports they could see before, or the reports show up completely empty for them. 

 

My Questions:

  1. How can we avoid constantly shifting users from one role to another just so they can see cross-country reports while maintaining access to their respective records? What is the cleanest architecture to decouple record visibility from report folder visibility?
  2. What is the Best Practice in Salesforce to solve this? Should we keep these global users in a specific role and grant them report folder access via a Public Group or a specific Permission Set?
  3. Why do some reports return empty or give errors to a user right after they are moved to a higher role in the hierarchy? Is it because of dynamic filters in the reports (like "My Team's Records" or "My Role" filters) that break when their branch changes?

Thank you so much for your help! 

 

@Salesforce Administrators & Developers, @Salesforce Administrators and Developers, @APAC Architects, @Data Quality & Management

 

 

#Trailhead Challenges  #Salesforce Developer  #Reports & Dashboards  #Solution Architects  #Sales Cloud

2 risposte
0/9000

when this error happens 

 Note: You have reached the maximum number (250) of deletable Reports at one time. If you would like to delete more Reports, first delete the ones below and then perform another mass delete.  

is there. a time limit that will let you go and delete the rest of them?

4 risposte
0/9000
Good day all,

 

I am trying to create a report to see how many opportunities have been created from converted leads and how many of them have closed. I have been advised to use a Joint Report with a cross-block formula. I have started working on it, but I can't figure out how to do it.

 

My instincts tell me that I should create a formula that will add a "1" to the Opportunity object report formula field when the contact's name matches a converted lead's name. Then, I will use that "1", the number of converted leads I have and the number of won opportunities to make other formula fields (%) to determine my closing ratio and the % of converted leads linked to opportunities.

 

In our org, opportunities are not created at the moment a lead is converted. A lead is converted to a contact when we are ready to pass them to sales rep. Considering how we work, the Leads with Converted Lead Information report type doesn't work with what I wanna do. 
5 risposte
  1. 28 apr 2016, 15:27
    The Cross Join report only works if the objects are related and Leads are not directly related to Account, Contact or Opportunity. What I have done in the past is create a field on Lead and Account called "IsConverted" or something similar. You can make it a check box if you want, and default the value to checked on Lead and unchecked on Account. Map the fileds together via Lead Field Mapping and then remove them from the page layout. Now you will track when an Opportunity is created if the Account came from a converted Lead. Then you can report looking at that field. 
0/9000
Lena Wong ha fatto una domanda in #Trailhead Challenges

Hi Trailblazers,

I am looking for best practices or automated workarounds to migrate Translation Workbench data specifically for Reports and Dashboards

from a Sandbox to target environments. 

 

Standard metadata deployment via VS Code / Salesforce CLI does not seem to easily retrieve or deploy these specific component translations, which often leads to time-consuming manual recreation in the target environment.

Since manual copy-pasting is not scalable for larger releases, what are the recommended practical solutions for deploying Report and Dashboard translations?

  • Are there specific Metadata API types or configurations required to fetch these translations?
  • Is there a known SFDX plugin, script, or AppExchange solution that handles this successfully?

Thank you for your advice! 

 

@Salesforce Administrators & Developers, @Salesforce Administrators and Developers, @APAC Architects

  

 

#Trailhead Challenges  #Trailhead  #Salesforce Developer  #Reports & Dashboards

2 risposte
0/9000

Saw a notice today about a number of security changes happening with SF and the ones I have some questions on are around the new MFA prompting for when they run or view/export reports.  I know we can set a cool down period, but it looks like at least every 2 hours anyone looking at a report will need to redo MFA is that correct?  What about reports on dashboard, etc? Just wondering if anyone has any insight. Prepare for the upcoming Step-up Authentication requirements on Report Actions

 

 

#Nonprofit #Reports & Dashboards #Salesforce Admin

111 risposte
  1. 15 set, 12:13

    The new security requirements are certainly making waves. Yes, the standard cooldown period is every two hours for report actions such as viewing or exporting. Dashboard components generally fall under the same umbrella since they pull report data. My advice would be to check your session settings early. The outcome usually means a little more clicking for users, but it helps keep donor data safe. A small price to pay for peace of mind, I think.

0/9000
Aviral Trivedi ha fatto una domanda in #Tableau Public

APAC Command Centre — a business performance dashboard with drill-down views across Product Performance, Customer Cost/Value, and Operations & Shipping, tracking gross profit, margin, and return rate trends.

Spotify Analysis — an end-to-end music streaming analytics build. Raw data cleaned and joined in Alteryx (900K+ play events, dedup, date/boolean standardization, a custom macro), visualized across an Executive Overview and Content Performance dashboard with parameter-driven Top-N views and a custom dark theme.

Would appreciate feedback on:

  • Visual design — readability, contrast, anything that feels off
  • Chart choices — anywhere you'd have visualized something differently
  • Navigation/drill-down flow — intuitive, or confusing anywhere?
  • Anything that reads as unfinished — direct critique welcome

Links below — thanks to anyone who takes a look! 

 

APAC Command Centre -

https://public.tableau.com/app/profile/aviral.trivedi/viz/APACCOMMANDCENTRE/HubOverview

 

 

Spotify Analysis -

https://public.tableau.com/app/profile/aviral.trivedi/viz/Spotify_Analysis_17884476660320/ExecutiveOverview

 

 

#Tableau Public  #Reports & Dashboards  #Tableau Desktop & Web Authoring  #Trailhead Challenges

1 risposta
  1. 14 set, 23:00

    Hi, @Aviral Trivedi

     

    Nice to meet you. 

    I'm still relatively new to Tableau, but I hope a fresh perspective might be helpful. 

    I'd like to share some feedback on the

    Spotify Analysis

    dashboard. 

     

    Overall feedback

     

    I liked the overall design. The Spotify theme makes the dashboard visually appealing, and using Spotify data immediately caught my attention because it's a topic many people can relate to. Also, it's impressive to see how dominant Taylor Swift is in the results. 

     

    1. Visual Design

     

     

    • I liked how the colors were aligned with the Spotify brand.
    • The navigation using icons for Overview, Content, and Geographic was clear and easy to understand at a glance.

    2. Chart Choices

     

     

    • In the Content page, I wasn't entirely sure what the crosstab was intended to show.
    • On the Overview page, I also found the Trend Line difficult to interpret. It wasn't immediately clear what insight I was supposed to take away from it.

    3. Navigation / Drill-Down Flow

     

     

    • The overall navigation and filters were intuitive and easy to use.
    • One thing I felt was missing was more interaction between charts. I would have enjoyed being able to click on a category or value and explore the data in more detail.

    4. Anything That Feels Unfinished

     

     

    • The "Trend Line of Plays by Month" appears almost completely flat, so at first I wondered whether the visualization was still a work in progress or whether the underlying values genuinely have very little variation.

    Overall, I enjoyed exploring the dashboard. Thanks for sharing it! 

0/9000