Skip to main content

#Reports & Dashboards148 discussing

Hello everyone. 

 

Does anyone know of a trailmix, badge, or trail that could help me create a reporting agent—an autonomous agent that generates business intelligence using natural language? 

I want to learn how to create an agent that will help me create a predictive experiment analysis. 

If anyone knows of a learning path, I would greatly appreciate the help. 

 

Greetings to all. 

 

#Trailhead Challenges  #Trailhead  #Analytics  #Reports & Dashboards

5 answers
  1. May 19, 3:43 AM

    Hi @Angel Rodriguez

     

    For learning this use case, I would recommend starting with Salesforce Agentforce, Einstein AI, and CRM Analytics/Tableau learning paths on Trailhead. There are several modules and trails focused on building AI-powered agents, natural language interactions, predictive analytics, and business intelligence automation.  

     

    A good approach is to first learn Agentforce fundamentals, then explore CRM Analytics datasets, predictive models, and Einstein Discovery for experiment analysis and forecasting. You can also check Salesforce AI demos, Agentforce workshops, and Tableau learning resources for practical examples of autonomous reporting and natural language querying. 

     

    https://trailhead.salesforce.com/content/learn/trails/get-ready-for-agentforce

     

    https://trailhead.salesforce.com/content/learn/trails/design-and-implement-ai-agents-with-agentforce

     

    https://trailhead.salesforce.com/content/learn/trails/get-ready-for-the-new-agentforce-builder

0/9000

Hi - Our sales team does their targeting by exporting opportunity data from SFDC to excel via a formatted report. One issue we are coming across is that when you export a report to a formatted view, a count row automatically appears at the bottom. Since the count row is a merged cell, users cannot sort their data in excel without removing the merged 'count' labelled column.    I am trying to find a solution where we can use formatted excel reports, but automatically remove the count row / column, so this is not a manual process for sales.    FYI - We prefer to use formatted report vs. CSV details since its more user friendly   

@Reports & Dashboards 

3 answers
  1. May 14, 3:26 PM

    Column C grouping seems to always appear in either a sum or count in every formatted report. This is very frustrating since you cannot sort the report until the column is removed.  

    Column C grouping seems to always appear in either a sum or count in every formatted report. This is very frustrating since you cannot sort the report until the column is removed.

     

     

0/9000

Hi All,    I'm trying to figure out a way to create reports for the platform events published and the streaming monitor app installed in Data Cloud. Is there a way we can set this up? Any inputs will be much appreciated     Thanks,  Clinton Fernandes     

2 answers
  1. Mar 24, 5:30 PM

    Hi @Clinton Fernandes

     

    I believe reporting isn’t available directly on Platform Events or Streaming Monitor; you need to stream supported events into Data Cloud via the connector, map them to DMOs, and then use Data Cloud or Tableau for analytics. 

    Thanks!

0/9000

Here is one that makes no sense.  I have a dashboard with lots of widgets based on opportunity reports.  I have dashboard filter for opportunity owner.  However, when I drill down, the dashboard is actually filtering on Created by and not Opportunity Owner. 

 

Thoughts? 

 

 

Dashboard Filter for Opp Owner end up filtering on created by

 

Dash Filter.png

 

 

 

 

#Answers  #Reports & Dashboards

4 answers
  1. May 19, 9:49 PM

    Love the "extremist" group.  

     

    So  turns out to be a complete rookie mistake, I guess.  I had standard and custom opportunity reports in the dashboard.  Apparently that isn't allowed.  I updated all my reports to standard and the filters are working.  Like anyone needs to lose hair over that one.  :)

0/9000

Is it possible to do inline editing for TIME fields in reports and list views? All the information I can find is for Date/Time fields and mostly from a few years ago. Are TIME fields (without date) available for inline editing in 2026? 

 

#Salesforce Admin  #Systems Administrator  #Admin  #Saleforce Administrator  #Reports & Dashboards  #List View

1 answer
  1. May 19, 8:15 PM

    @Yamilé Pacheco Cueva Time-only fields are not currently supported for inline editing in standard Salesforce reports or list views.

    Reports inline editing supports only certain field types. Salesforce release notes mention text, numeric, checkbox, date, picklist, and lookup support, but not Time fields.  

    Reference: https://help.salesforce.com/s/articleView?id=release-notes.rn_rd_reports_inline_editing.htm&release=234&type=5

     

    For list views, Salesforce also says not every field supports inline editing. The practical test is whether the pencil icon appears when you hover over the field.  

    Reference: https://help.salesforce.com/s/articleView?id=xcloud.customviews_edit_inline_listview_lex.htm&type=5

     

    There is a similar community post for custom Time fields where the suggested workaround was customization, such as a custom Lightning component or Visualforce-style grid: https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000H2xBUSAZ

     

    Practical options are to edit the Time field from the record page, use Data Loader/import tools for bulk updates, build a small screen flow/custom LWC for controlled updates, or use a grid-style AppExchange tool if users need spreadsheet-like editing.

0/9000
11 comments
0/9000

Hi Salesforce experts,

I’m looking for a solution to display a tabular/detail report (no chart) on Lighting page or visualforce page. 

Any idea on how i could accomplish it? 

Thank you

#Reports & Dashboards #Lightning Experience Reports #Report

5 answers
0/9000

Following up the above , 

We can fetch the click details through MCAE API connection and download that report through SFTP server. 

 

For the above statement we definitly need any middleware to implement the API query and see the results.  

  

Is there any integration documentation to implement middleware to fetch API query and see the results?

#Salesforce Developer  #Reports & Dashboards  #Pardot B2b Marketing Automation

2 answers
  1. May 15, 5:31 PM

    @Selvasubha R there is no single Salesforce document for “MCAE API query -> generate file -> push to SFTP” because the SFTP/file-generation part is a custom middleware responsibility.

    For click details, use the Account Engagement API, usually Visitor Activity. Click activities are available there, including activity type 1 for Click and 21 for Custom URL Click: 

    https://developer.salesforce.com/docs/marketing/pardot/guide/visitor-activity-v5.html

    For larger exports, use the Account Engagement Export API instead of normal synchronous queries: https://developer.salesforce.com/docs/marketing/pardot/guide/export-v5.html

    The usual architecture is: MCAE API -> middleware job -> transform response to CSV -> upload CSV to SFTP. The middleware can be MuleSoft, Boomi, Workato, Azure Function, AWS Lambda, Python/Node scheduler, etc. Salesforce will provide the API endpoints and authentication, but the SFTP upload, file naming, scheduling, retry logic, and logging need to be built in the middleware.

    If this is Marketing Cloud Engagement SFTP, Salesforce documents SFTP usage here: https://help.salesforce.com/s/articleView?id=mktg.mc_overview_ftp_accounts.htm&type=5

    For Account Engagement specifically, treat the API as the data source and the SFTP delivery as a custom integration layer.

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

10 answers
  1. Yesterday, 11:23 AM

    Hi 

    I have let my Users know and I guess we'll have to see what an issue it becomes if any

0/9000

I am struggling with some limitations of native Salesforce reporting and wondering if it's time to move to PowerBi or Tableau. We are a nonprofit working to reduce poverty in our community. One of the primary challenges is that we have a "lifetime" model, which means that people can engage in our services, disengage and then re-engage at a later date, as long as they are still in poverty (mix of federal guidelines and our own cost of living data). Each time a person engages with us, we create a new Intake and that Intake is then connected to other objects like trainings, employments, service plans, etc. So in effect each Intake (we call it Program Engagement) is like a chapter of a person's journey with us. This allows us to do some time based reporting as well as holistic outcomes. The challenge is that not everything is connected to a program engagement, as some things are more "evergreen" and not just tied to a specific point in time. For example we track referrals, and since people can come and go, the place they were referred by "today" may not be the place they get referred by 2 years from now. We can get a LOT of reporting via native reports, using report types, lookups, etc however, there are just times when the lifetime model creates some data/outcome "noise". So I am wondering if moving to PowerBi or Tableau would be the best long term solution, however, those solutions do come with a new learning curve, costs, etc.  As we want to keep people in Salesforce as much as possible and not have some Dashboards in SF and then other dashboards in PowerBi, etc.  So what are the pros/cons? Price is one, visibility is another, as not everyone needs to create Dashboards/reports but still need to view them. So....? 

 

#Reports & Dashboards #Nonprofit #Systems Administrator

5 answers
  1. Khyati Mehta (InfinySkills) Forum Ambassador
    May 3, 3:35 AM

    Hello Heath, 

     

    Honestly, what you’re describing is exactly the kind of scenario where Salesforce native reporting starts to feel stretched. It works great for structured, object-based reporting, but once you get into a lifetime journey model with re-engagements, mixed time contexts, and loosely connected data, it creates noise that’s hard to cleanly model in standard reports. That’s usually the signal to at least consider something like Tableau or Power BI — not because Salesforce is failing, but because your data storytelling has become more complex than what report types and joins can comfortably handle.

    That said, I wouldn’t jump tools immediately. External BI tools shine when you need cross-object, time-series, historical layering, and flexible data modeling — basically building a cleaner “analytics layer” on top of Salesforce. They’ll let you reshape your data and remove that noise. 

    A lot of orgs in your situation land on a hybrid approach — keep operational dashboards in Salesforce, and use Power BI/Tableau for impact reporting, leadership insights, and longitudinal analysis where your lifetime model really matters. So yes, it’s less about when to move completely and more about when to extend, and from what you described, you’re pretty close to that point. Hope this helps!

0/9000