Questions tagged [custom-reports]
The custom-reports tag has no usage guidance.
223
questions
0
votes
0
answers
21
views
Returning Count is different for Reports for two different Profiles
I have created a report with Filters I got like 300 run values another Person with a different Profile has created a report with the same filters that I used but they received 250 as run values.
What ...
- 21
0
votes
0
answers
59
views
Joined reports error: no common fields on the report type
I have two report types:
Report type A: Contact Roles
Report type B: Sport Affiliations
They both share the Lookup field "Account".
But still I get this error:
"Choose a different ...
- 277
0
votes
0
answers
70
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 (...
- 372
-1
votes
1
answer
41
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 ...
- 17
0
votes
0
answers
69
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 ...
- 1
1
vote
0
answers
41
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 ...
- 297
0
votes
1
answer
38
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)...
- 1,239
-1
votes
1
answer
27
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 ...
- 537
0
votes
0
answers
42
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 ...
0
votes
0
answers
27
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 ...
- 1
1
vote
1
answer
211
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 &...
- 135k
-1
votes
2
answers
34
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 ...
-1
votes
1
answer
477
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 ...
0
votes
0
answers
67
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 - ...
- 1,551
0
votes
1
answer
388
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; ...
- 3
-1
votes
1
answer
426
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-...
0
votes
1
answer
71
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 ...
- 1
0
votes
0
answers
234
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 ...
-1
votes
1
answer
107
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 ...
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 ...
-1
votes
1
answer
378
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 '...
- 53
-1
votes
2
answers
90
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 ...
0
votes
2
answers
663
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 '...
0
votes
0
answers
512
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 ...
- 1
0
votes
0
answers
743
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 ...
- 1
0
votes
1
answer
295
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 ...
- 17
0
votes
0
answers
488
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). ...
- 1
-1
votes
2
answers
347
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
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 ...
- 158
0
votes
0
answers
81
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 ...
- 808
0
votes
0
answers
79
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 ...
- 65
0
votes
0
answers
285
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 ...
- 7,765
1
vote
0
answers
133
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 ...
0
votes
0
answers
168
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 ...
- 11
0
votes
1
answer
179
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 (...
0
votes
1
answer
1k
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.
...
- 1
0
votes
1
answer
467
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 ...
0
votes
0
answers
74
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
0
votes
0
answers
63
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 ...
- 11
0
votes
1
answer
118
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.
- 1
0
votes
0
answers
664
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 ...
- 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 ...
0
votes
0
answers
267
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 ...
- 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 ...
0
votes
0
answers
310
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 ...
- 1
0
votes
2
answers
5k
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 ...
- 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 ...
- 141
0
votes
2
answers
1k
views
How to query/make a report for All fields on All objects? [duplicate]
We have a very old org with many objects and unused fields, how can i query/make a report to find all fields for all custom objects, and order them by lastmodified date?
the goal is to find which ...
- 11
-1
votes
1
answer
527
views
Not available Case Information fields in report type
I'm trying 2 Report types and I have problems with fields availability.
REPORT TYPE 1: Cases standard report type. With this, I can access to 'Case information' fields like Age, Opened Date, and so on....
- 335
0
votes
1
answer
787
views
How to filter a Dashboard using a formula field?
I have a dashboard that I wish to display on clicking a link. This link has to be prepared in a way the dashboard filters and displays the components only for the products that are associated with the ...
