Skip to main content

#Reports & Dashboards108 人がディスカッション中

Hello,

 

In Create Reports and Dashboards for Sales and Marketing Managers

 

Filter Your Reports trailhead I am getting error that says,

 

The 'Central and Eastern Target Accounts' report does not appear to have a filter where Prospect Rating equals 'Hot, Warm'.

 

I used  

 

3. Account Rating equals "Hot,Warm" for my values. Did not see Prospect rating in fielkd dropdown. Only option with rating was Account rating and that does not sem to work.

 

thanks

 

 
7 件の回答
  1. 昨日、13:16

    Same issue, even tried Rename Tabs and label but there is no Prospect rating or Rating. 

    Same issue, even tried Rename Tabs and label but there is no Prospect rating or Rating.

     

     

0/9000

GOAL: Show Week over week report of what deals changed in the pipeline excluding closed won or closed lost deals 

 

Built a custom object (Pipeline Growth Snapshot) that takes a weekly snapshot of open opportunities to support week-over-week pipeline trend reporting. It works well for open deals, but we've found that once an opportunity closes (Won or Lost), it only gets captured one more time, the week it closes, and then never again. 

 

This creates a reporting problem: our week-over-week reports compare this week's number to last week's. Once a deal's snapshots stop, the next comparison is a real number vs. nothing, which displays as a large drop, even for deals that closed Won. There's no way from the report side to tell a real loss apart from a win that simply aged out of the snapshot window. 

 

Questions for anyone who's solved this: 

 

  • Is there a standard pattern for extending snapshot capture for closed opportunities (e.g., for 30-60 days post-close) specifically to support trend reporting, without keeping every closed deal in the snapshot indefinitely?
  • Has anyone used native Historical Trend Reporting instead of a custom snapshot object for this, and does it have the same limitation?
  • Any recommended way to flag, on the report itself, whether a dollar change came from a win versus a loss, without needing a live cross-object Stage lookup (our report type doesn't expose the Opportunity's live Stage field, only the snapshot's own captured Stage)?

Appreciate any patterns or gotchas others have run into with this. 

 

#Reports & Dashboards  #Reporting  #Reports

3 件の回答
  1. 8月18日 18:44

    Happy to share what has worked for me. I would actually split your problem into two tools, because 'the forecast number' and 'what moved in the pipeline week-over-week' are best served by different native features: 

     

    For WoW deal movement (your actual goal): before maintaining a custom snapshot, look at two native options that keep closed deals in the dataset: 

    - Pipeline Inspection: its 'Changes Since' pipeline-changes waterfall shows exactly what moved between two dates, amount increased/decreased, stage changes, close-date pushes, and deals that closed Won/Lost. That is the week-over-week story you built the snapshot for, without the open-only fall-off (Enterprise+ with Sales Cloud). 

    - Historical Trend Reporting (the 'Opportunities with Historical Trending' report type): natively snapshots Amount/Stage/Close Date daily for the trailing ~3 months and lets you compare across dates in one report, no custom object to maintain, and closed deals stay in the data. 

     

    For the forecast number itself: Collaborative Forecasting (Forecasts tab) rolling up by forecast category (Pipeline / Best Case / Commit / Closed) against quota and role hierarchy. If you have Sales Cloud Einstein, Einstein Forecasting adds a predicted-to-land number and Opportunity Scoring to weight deal health. 

     

    Methodology I lean on: Collaborative Forecasting for 'where will we land,' Pipeline Inspection or Historical Trending for 'what changed and why since last week,' and Opportunity Scoring to weight the pipeline. That combo answers WoW movement AND the landing number without hand-rolled snapshots. 

     

    3rd-party, if native is not enough: the revenue-intelligence platforms, Clari, Gong Forecast, Aviso, Mediafly (InsightSquared),

    People.ai

    , all do pipeline-change waterfalls, WoW deltas, and AI forecasting on top of your Salesforce data. Teams usually move to these when they want rep-level forecast submissions plus inspection plus analytics in one place. 

     

    Honestly, if Pipeline Inspection is available in your edition, I would try its change view first, it may let you retire the custom Pipeline Growth Snapshot object entirely. 

     

    If this helps, please mark it as the Best Answer so it is easy for the next person to find. Thanks :)

0/9000

Hello Salesforce community, 

 I’m Salesforce AI Certified with year and half of experience at Apple and Seagate. I’m currently looking for opportunities to volunteer my Salesforce skills and support a nonprofit organization. 

 

I’m currently looking for opportunities to build hands-on experience with Salesforce and would be interested in either volunteer or professional opportunities where I can contribute my skills. I would really appreciate if you could direct to any nonprofits, organizations, or teams looking for Salesforce support. Thank you for your time! 

 

#Volunteer Opportunities  #Salesforce Admin  #Agentforce  #Flow  #Reports & Dashboards

1 件の回答
  1. 8月17日 17:29

    Hey Nupoor, 

     

    Great that you're looking to give back, a few solid places to start: 

     

    1. Complete the "Pro Bono Basics for Salesforce Professionals" trail on Trailhead first, it's specifically designed to prepare volunteers like you and helps you figure out where your skills fit best before you commit to a project 

     

    2. Salesforce's Impact Exchange (evolution of the old Pro Bono Program) is the main channel connecting volunteers with nonprofits/educational institutions looking for Salesforce help, worth checking there directly 

     

    3. This community group itself (

    #Volunteer

    Opportunities) is actively used by nonprofits posting real project needs, keep an eye on new posts here, and don't hesitate to post specifically saying "1.5 years experience, AI certified, available for X hours/week" since specificity gets more responses than a general intro post 

     

    4. Join your local Nonprofit or Higher Ed Trailblazer Community Group, a lot of pro bono matching happens informally through these local meetups rather than a central job board 

     

    5. Since you're AI certified specifically, mention that clearly when reaching out, nonprofits are increasingly interested in Agentforce/AI use cases but very few volunteers have that skill yet, it's a strong differentiator for you right now 

     

    One tip: many nonprofits prefer volunteers to have (or be working toward) the Nonprofit Cloud Consultant certification, not required to start volunteering, but worth knowing if you want to specialize in this space long-term. 

     

    Reference:

    https://trailhead.salesforce.com/content/learn/trails/volunteer-your-salesforce-expertise

     

     

0/9000

Hello, 

 

I am trying to create a report that shows the cumulative surplus/deficit against the target, divided out over the remaining months of the financial year, to create a "real" target. For example, if by the end of January we are in a deficit of £1,000,000, the remaining 6 months will each need to achieve their original target but also an extra £166,666 to make up for the deficit so far. Note: we use the education year of Aug to July. 

 

I have a column for monthly surplus/deficit and a column for running surplus/deficit, but I am struggling to get a column that shows the current running surplus/deficit divided by the remaining months. Below is my report so far with dummy data: 

Formula to divide the surplus/deficit over the remaining months

 

And this is what I am aiming for (as we are in July, I have taken a few months out to show the intended use)

image (2).png

 

Note: End Date is the last day in the month; just set to calendar month here 

 

What is the best way to get this result? 

 

 

 

#Reports & Dashboards

6 件の回答
  1. 8月2日 18:51

    Your running surplus/deficit approach looks solid; the remaining step is just dividing it by the number of months left in the financial year so each month's adjusted target updates automatically. Helpful walkthroughs like this, along with https://y9.com.pk/, are always worth recommending. 

0/9000
I need to clone a dashboard and have not been able to find step-by-step instructions for doing this. Also, what do I need to know about the underlying reports when I clone a DB?

 

I also need to add a new component, I think it is, to an existing dashboard. I've looked through the help and training and also the Q&A forums and haven't been able to find what I need.

 

I know this is basic stuff, but I'm definitely still a newbie. 

 

Thank you!
13 件の回答
  1. 8月14日 7:19

    Ran into this every quarter when we spun up regional copies of the same dashboard.

    Save As gives you a new dashboard pointing at the old reports, which is almost never

    what you want. 

     

    What we did before: Save As on all the reports into the new folder, clone the

    dashboard, then click through every component swapping the source. An hour if the

    dashboard is big. 

     

    I eventually built a Chrome extension to do it, copies the dashboard and its reports

    and connects them up.

    https://sf-report-manager.com/clone-salesforce-dashboard-with-reports.html

    It's mine, so obviously biased. The manual route above is fine if it's a one time thing.

0/9000
We are installing a new Division and would like to copy/clone several reports at once from an existing Division. Each Division has about 50 or more reports they use. 

 

Thanks for any help
3 件の回答
  1. 8月17日 6:41

    Nothing native in 2026. It's Save As one by one, or the Metadata API (retrieve folder, duplicate report XML, deploy back), which works but is fiddly.

    I built a Chrome extension for exactly this: select the reports, pick where they go, run it as one batch. https://sf-report-manager.com/bulk-copy-salesforce-reports.html Made it for my own admin work.

0/9000

I need to create a report which shows last year and this year month side by side to see new opp created month over month current year and last year. 

Bar chart showing  

opp created by value or count on y axis and x axis should have month of last year and current year next to each other showing month over month trend. 

Jan 25 jan 26 feb 25 feb 26   

 

I have similar report for leads which has two created date fields which I can use in Group rows and group columns however cant use created date same way in opp report. Once I use created date field in group rows , there is no created date field to use in group columns. 

 

#Reports & Dashboards

3 件の回答
  1. 8月17日 13:28

    You need to create a "duplicate" CreatedDate field, kind of like the built-in CloseDate 2, Close Month, and Year fields.  

     

    All you need is a Formula(DateTime) field or Row-Level Formula, and just insert the standard CreatedDate API field name.  Then use that as your 2nd Row / Column Group

0/9000

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 件の回答
  1. 8月16日 7: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!

0/9000

Once a month, I use PeekLogic Report Sender to export Excel reports to people who do not have Salesforce licenses. This month, the reports required authentication before download, and they cannot authenticate. Is this a known issue, or is something else going on that I need to address, like an issue with PeekLogic Report Sender?  

 

#Reports & Dashboards

8 件の回答
  1. 8月4日 18:14

    Hi @Kathy Latiolais DeGlandon

     

    Looks like this is due to Salesforce's new

    Step-Up Authentication for Anomalous Report Export security control (Prepare for Step-up Authentication in Anomalous Report Export

    ).   

    Salesforce began enforcing this in production on

    July 27, 2026. When Salesforce's ML detects unusual behavior on a report action — running or exporting a report — it forces the running user

    to complete a step-up MFA challenge before the export completes. 

     

    What to check/do 

    1. Confirm the running user's MFA setup. Go to Setup → Users → find whatever user PeekLogic runs as (its named/integration user). Make sure it has a registered MFA verifier, or at minimum a valid email/phone for verification.
    2. Look at Identity Verification settings in Setup for the "periodic step-up authentication for reporting/printing" toggle CertifyCRM points to — this is org-wide and worth knowing where it lives even if you don't disable it.
    3. Ping PeekLogic support directly. Ask whether they've adapted their export logic to avoid tripping the anomaly model.
    4. If it's blocking a business-critical monthly deliverable, this is legitimate grounds to log a case with Salesforce.

    Hope this helps.

0/9000

My Lead View, Mass Email View, and Report View do not return the same counts even with identical filters and logic. One of the fields was imported with multiple options in the field. Some Examples below.  We are using enterprise classic and the mass email lead tool in Salesforce.  I researched several articles that make me think it's the multiple field options but nothing showing a work around. I am a admin by default, I'm not a dev, or wizard, so any help - insight would be greatly appreciated! I'm exhausted from trying so many different ways to come up with 3 exact numbers all weekend that my eyeballs are killing me :( 

Expanse, MaaS,  

MaaS 

Client Server, Expanse 

Meditech 6.x, Expanse  

 

 

#Reports & Dashboards  #Mass Email  #List View

12 件の回答
  1. 8月11日 17:09

    finally got all 3 to match

0/9000