Questions tagged [custom-reports]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

For the filter: Invalid date (Valid date format D/MM/YYYY)

Our report does not work when we add a formula(Date) field on the report filters and whose value is set to a relative date such as CURRENT FISCAL YEAR. The error is: For the filter 3: Invalid date (...
dev4life's user avatar
  • 362
-1 votes
0 answers
14 views

How to show data of a team in reports and dashboard?

I have requirement of showing data of a team in reports and dashboard. See the attached Image - In this Image, 20, 18, 20, 18 is record count of records created by each Manager. I am able to plot the ...
Parvez Alam's user avatar
-1 votes
0 answers
10 views

How to show data on Reports/Dashboard till particular level of role hierarchy?

I have a requirement of showing data on reports/dashboard for logged-in user till a particular level of Role hierarchy. For Example, If CEO is logged-in into the Salesforce Instance he can see every ...
Parvez Alam's user avatar
0 votes
0 answers
57 views

Row Level Formula With Picklist

I am trying to say if campaign names are equal to certain names, then change from registered to attended, otherwise just put the results of the field. The issue is that the field is a picklist so ...
AaGel12's user avatar
-1 votes
0 answers
20 views

How to create report and Dashboard for Forecasting Quota?

I have a Use Case in which we have custom LWC component in which we choose a tool and a form opens which allow user to create a custom Object record. I need to show a chart which shows the total usage ...
Parvez Alam's user avatar
1 vote
0 answers
21 views

How do you effectively use URL parameters to manage a large number of dynamic Reports?

This question is borderline opinion based, but hopefully still acceptable. How do medium to large organizations manage Reports that should have dynamic parameters? Consider a company that has ...
kennyc's user avatar
  • 253
0 votes
1 answer
23 views

Unable to find standard report type "Opportunity History" in reports

I am the admin for my salesforce org. During report creation, I can't to view the "Opportunity History" report in the report type lists on my report type selection screen. (Refer below image)...
Mohanraj Sivalingam's user avatar
-1 votes
0 answers
25 views

Field History Report That Only Shows the Most Recent Change to the Field?

I'm trying to build a report to show the most recent change to a particular field within our Opportunities. I already have the tracking set up and can build a report showing all the changes to that ...
James Finney's user avatar
-1 votes
1 answer
24 views

Reports to cleanup

I am trying to get a list of reports that need to be deleted from Salesforce. I have created a report of reports with the below criteria. The report seems fairly accurate and I am trying to get the ...
Balaji Pooruli's user avatar
0 votes
0 answers
40 views

How to filter to latest date of Opportunities on an Account

I’ve spent a good amount of time trying to figure out or find this answer - I created a report showing fields from both Accounts and Opportunities and there are sometimes multiple Opportunities tied ...
Kari Hedrick's user avatar
0 votes
0 answers
26 views

Not seeing the object I want for the c level of a new custom report type

I cannot figure this out for the life of me. We have pretty much all custom objects (most are via a managed package from the exchange app ADvendio). I'm looking to simplify the way we process ...
Courtney's user avatar
1 vote
1 answer
78 views

How to report on the status of email messages related to a specific record?

I'd like to create a report that presents information such as the EmailMessage.LastOpenedDate and the EmailMessage.Status for emails sent that are related to a specific custom record. When I look in &...
Keith C's user avatar
  • 134k
-1 votes
2 answers
31 views

Report not showing records created by another user

I created a report for a custom object, but the report doesnt show all the records I want it to show. The difference between the records that show up and the ones that I don't seem to be whether or ...
Hans Rogg-Desormeaux's user avatar
-1 votes
1 answer
255 views

Blanks filter doesn't works

I created a Salesforce report and want a field to be filtered to only show the ones containing certain text. I used a filter with contains: MXN APT SET It shows those (about 800 results) but also the ...
Dorinicee's user avatar
0 votes
0 answers
56 views

Rolling Average Report for Closed Deals By User in Salesforce

I am trying to create a Rolling Average Report in Salesforce to show the Rolling Average of Deals Closed by each User. Example Of Rolling Average : USER 1 JAN - Average of Jan Closed Deals FEB - ...
Rajasekhar's user avatar
  • 1,541
0 votes
1 answer
309 views

Issue on Report Edit

I am trying to edit one report. as soon as i click on edit button of report, i was getting this below error. This page has an error. You might just need to refresh it. [Minified React error #185; ...
Priya's user avatar
  • 3
-1 votes
1 answer
269 views

Can I transpose columns to rows in a SFDC report?

If I dont have Einstein Analytics, and I want to report on a single object, and transpose few columns into rows, with rest of the fields repeating, is this possible in another method in the Out-of-the-...
Eashwer B. Iyer's user avatar
0 votes
0 answers
47 views

How do I make a cross tab report where the intersection is a text field value?

I am using Salesforce to track milestone completion for PhD students. I would like to make a crosstab report that shows the student names down the left, milestone names across the columns, and then ...
Nick's user avatar
  • 1
0 votes
0 answers
190 views

How to divide row count over a specific column in a report

I have a matrix report of opportunities, and stages group the columns. I need to divide the row count of each stage over the first stage (column), for example, first column / second column, first ...
Nestor Romero's user avatar
-1 votes
1 answer
74 views

Link to report without report ID

Is there a way to create a relative URL link to a report? For example, a link that would be valid in test, QA, and prod. Since the report ID would be different in each environment, would need a way to ...
Douglas Mason's user avatar
0 votes
1 answer
29 views

Reporting structure --> column level summary formula aka, how many accounts have no invitation

so i have a propblem regarding Reporting Some Numbers : in Our Structure to All accounts, some have contacts and from some of these Contacts the field we Called : customer portal status, is either ...
Lionceau Osahon's user avatar
-1 votes
1 answer
179 views

Reports: Accounts with Opportunities

I am trying to build a report in Salesforce. I am using the Accounts report type. For context, I have 5 Accounts and each Account has 5 Opportunities. If one of the Opportunities contains the word '...
spal's user avatar
  • 53
-1 votes
2 answers
80 views

Row-Level Formula

What is wrong with my formula am getting the following error: IF((AND(ISPICKVAL(STATUS, "RESOLVED")))'&&'((CREATED_DATE - LAST_UPDATE))>48) Warning Error when encoding row-level ...
Magezi Raymond Ssebyala's user avatar
0 votes
2 answers
528 views

Datorama (Marketing Intelligence) Calculated Dimensions AND statement

I'm trying to set up some custom filters to combine data from a few sources, using Calculated Dimensions. I'm able to create a single filter using: IF([Web_Analytics_Site_Campaign] contains '...
jdblundell's user avatar
0 votes
0 answers
409 views

"The request body is either invalid or incomplete."

I'm using the analytics studio to build a dashboard right now. I put 2 reports about campaign influence, that I created via "Reports", one for customers and one for prospects. I want to put ...
Erugar's user avatar
  • 1
0 votes
0 answers
632 views

App Customization Specialist issue- Build Volunteer Tracker app reports

I'm getting error as : Challenge Not yet complete... here's what's wrong: The 'My Upcoming Confirmed Shifts' component is using the incorrect source report. I have used My Upcoming Shifts report in ...
Ravinder's user avatar
0 votes
1 answer
239 views

Incoming chats per hour in a report

I am looking for a way to capture the number of incoming chats we get per hour for a particular month. For example : The number of incoming chats per hour for the month of November. Is this achievable ...
AlizehS's user avatar
  • 17
0 votes
0 answers
444 views

How can I report in Salesforce cases open vs closed in one day

We are trying to build a report in Salesforce for the last 30 days that shows for each day, the amount of cases opened and the amount of cases closed(in total, not how many of the opened were closed). ...
kaizen's user avatar
  • 1
-1 votes
2 answers
296 views

Case Feed Object's field 'Body' is not showing up on filter - Reports

Case Feed Object's field 'Body' is not showing up on filter - Reports..But I am able to add the field 'Body' as column on reports
Mohammed Musaddiq's user avatar
1 vote
1 answer
1k views

Show Me "All Opportunities" randomly filters the data by Role

I am experiencing some major frustration with a matrix report. I have a report that shows opportunities grouped by Closed date and then by a Custom grouping value I would like the report show include ...
Ben Plunkett's user avatar
0 votes
0 answers
72 views

How to save a report's result as a csv document in salesforce

I have a report that needs to run monthly and save its result as a CSV document inside salesforce. The report is currently scheduled to run and send the result as an email but the request is to change ...
Bahman.A's user avatar
  • 798
0 votes
0 answers
67 views

How to get Next Group record count in report

I am creating one opportunity report that will show the percentage to complete the next stage. And the report is having group by Stage field. Formula - (Next stage record count/Current stage record ...
Ragavendra's user avatar
0 votes
0 answers
241 views

Salesforce Report Options for Notes and Attachments with a Custom Object

I have a requirement to show a report for notes and attachments which are associated with a parent custom object. with salesforce reports its a limitation and we cannot link notes and attachments with ...
RedDevil's user avatar
  • 7,745
1 vote
0 answers
127 views

Report : Save hierarchy level not working

When a user creates a report with specific filters, they were unable to see results. As a admin i'm enabling the Save Hierarchy Level in report properties. After some time again the user cant see the ...
Emmanuel Angelo.R's user avatar
0 votes
0 answers
140 views

Custom fields are not visible in custom report type

I am not able to see all the custom fields of an object in custom report type which is recently created. I have opened the report type and tried to edit the layout but the custom fields are not ...
Guest's user avatar
  • 11
0 votes
1 answer
143 views

How to Show Current Fiscal Year's Revenue from Accounts Created From Google Ads Prior to This Year?

I'm trying to create a report that allows me to see closed won opportunities from the current fiscal year, but only from accounts created prior to this year and created from a Google Ads campaign (...
Jeff Purcell's user avatar
0 votes
1 answer
898 views

Is there away to schedule a report which contains all the email sends and it has be sent to a particular email ids on weekly basis in marketing cloud

I need help to create report for all the journeys which we have triggered and this report has to be mailed to a particular set of email ids automatically on weekly basis. Is there a way.. pls guide. ...
DSK's user avatar
  • 1
0 votes
1 answer
383 views

Report to show "My" Accounts but based off different User Lookup instead of Account Owner

We currently have an additional custom user lookup field on Accounts called CS Rep. I am trying to dynamically run the report as if I were the CS Rep. This way I can run a single report to send to ...
NoviceAdmin80's user avatar
0 votes
0 answers
91 views

Filter Report Closed Date to only show closed cases within the past 12 months

I want filter report to show all close date within pass 12 months. It works for last week, last month but its not working when I filter by close date within the pass 12 months from the close date.
Queen's user avatar
  • 1
0 votes
0 answers
64 views

How to write summary formula to calculate percentage based on coloums total?

I did some research but i am unable to get it. I want to create a formula for this calculation: Total Records- Total CompletedOnboarding/Total Records *100. Please guide
Rajiv Singh's user avatar
0 votes
0 answers
261 views

Cannot see the report list in Community

Hi in my community want to show the Menu item called by myself Reports from the type Site List and page Report List. I already have a shared folder shared with the user from my community that is ...
user avatar
0 votes
0 answers
58 views

Some Quote Numbers are not showing in my custom Report

I have a group of rows of Service Branch and Quote Number, Service Branch is "MO Branch", and Other Quote numbers have the value of Service Branch "MO Branch". My question is why ...
user123152's user avatar
0 votes
1 answer
107 views

query only recalled record for approval process

I have a requirement in which I need to query only those record which are recalled, is it possible for using query or through report.
Ali Khan's user avatar
0 votes
0 answers
569 views

Count the number of Groups in a report in Salesforce

I am trying to create a report of Account and Orders where I am grouping by account to get the accounts with at least one order. I want to count the number of Accounts(which is number of groups) with ...
Isha's user avatar
  • 163
0 votes
0 answers
1k views

Average Record Count Per Month Report

I am looking to create a column on a report that shows the average record count per month. I am unable to add a row level formula to this report. The blacked out parts on the image represent the ...
user120752's user avatar
0 votes
0 answers
237 views

Dashboard problem in Mobile App

I have a problem with my Dashboards in mobile app. I have created two Dashboards. I put these Dashboards in a Home Page with conditional visibility based on the country of the running user. For the ...
Grace's user avatar
  • 1
1 vote
1 answer
1k views

Formula Field to calculate conversion rate of one stage over another stage in contact object in reports

My requirement is I have a custom picklist field in the Contact object name stage, like MQL(Mkt qualified Leads and DQ(Disqualified leads) SQL(Sales Qualified Leads) Now I would like to calculate and ...
Nishant Chaudhary's user avatar
0 votes
0 answers
266 views

For custom report types with one-to-many object relationship, how to filter *after* join

(NB: As per comments, this is specifically a technical question around Salesforce reporting capabilities.) Reports using the standard report type "Opportunities with Products" will include ...
Joe's user avatar
  • 1
0 votes
2 answers
4k views

Way to filter by row group count > 1

Requirement is to filter for report with multiple complaints for same customer. Added account as grouping by row but unable to filter the group count > 1 kinda of statement. How to achieve this in ...
Yogi's user avatar
  • 153
-1 votes
1 answer
1k views

Report with Contacts with Activities and Opportunities [closed]

I am trying to create a report in Salesforce that will display all contacts that have activities and opportunities. Is there any easy way to do this or is it even possible? I tried doing an activities ...
MarkC5000's user avatar
  • 141

1
2 3 4 5