Skip to main content

Questions tagged [custom-reports]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
19 views

Show all records from report via LWC

I'm displaying report records in an LWC page, but I'm only getting 2000 records, even though the report has over 10,000 records. It seems that the report data is limited to 2000 records. How can I ...
Mansy's user avatar
  • 1
0 votes
1 answer
26 views

Control user level data visibility in reports

I have created an opportunity report from admin(admin able to view all the opportunity records) and place the report on a folder and provided view access to sales rep. when a sales rep runs the report,...
soniya g's user avatar
-1 votes
0 answers
31 views

P90 - 90th percentile in report

My requirement is to find the 90th percentile (P90) from a list records, which are displaying a in reports. For example: Employee Number and age are displaying in summary reports reports. Ages will be ...
Surendra's user avatar
0 votes
0 answers
16 views

How to show Einstein Activity Capture Outlook Events into Custom Reports and Dashboards in Enterprise Salesforce Org

I want to get Outlook events captured by Salesforce's Einstein Activity Capture into custom reports and dashboards within our enterprise Salesforce organization. Through my research, it seems that ...
Tanishque Jain's user avatar
0 votes
0 answers
23 views

Relative Date Filters - Other options besides 'LAST WEEK' , 'THIS MONTH' etc

I am aware of the relative filters such as 'LAST WEEK', 'THIS MONTH' etc, but I am looking to pull data for 1/2/3/4 weeks in advance and the same in the past - At the moment I am having to manually ...
HarryParfit's user avatar
0 votes
1 answer
24 views

'Range' filter not showing in report

I want to use the 'Range' function on a Created Date field in a report. See the image below for reference: But I don't see the 'Range' function. See the image below: Is there anyway to bring the '...
MShal's user avatar
  • 31
0 votes
0 answers
17 views

Bar report with x axis values ​which is a text field and y axis names in Lookup field

I currently have an object in which there is a Lookup field as well as a text field I would like to have a report in which each row is a unique lookup name and each column is a unique value in this ...
arnaud's user avatar
  • 106
0 votes
0 answers
12 views

Create report on parent object based on child object

We have a requirement to create a report that shows all accounts for which opportunities were created in last seven days with certain values. an account should be shown only once even if there are ...
Abhinav's user avatar
  • 11
0 votes
0 answers
22 views

How to generate report on Contracts and Opportunities combined

I would like to report on Contracts that have Amendment Opportunities. I don't seem to get the accurate data using custom "Opportunities with Contracts" report type. Would Workbench help? or ...
DigitalCS's user avatar
0 votes
1 answer
30 views

VisualForce apex markup code to open salesforce report using its name

I am having scenario where salesforce tabular report needs to be opened using the report's name(and not id) through VF Markup. I have tried the following in VisualForce Markup and a new page opens but ...
bibar's user avatar
  • 13
0 votes
0 answers
19 views

Create report including knowledge title and topic name

We are trying to build a report to include both knowledge title and topic name. However, topic assignment doesn't give options to show related articles as well as they don't allow to traverse generic ...
Patlatus's user avatar
  • 17.3k
-1 votes
1 answer
206 views

History Field Tracking - Reports / Object - Task

I have a question: a client is asking me to track many task fields for audit purposes. According to what I saw in the documentation, in the task object, you can track up to 6 fields. Additionally, ...
Jonathan Grosso's user avatar
0 votes
0 answers
19 views

Making Record Count Cumulative Across Monthly Grouping In Report

I have a report for custom object, Tasks. There's a column for the task name and then I've grouped the forecasted date for each task by row and by month. Example: Task Name Forecast Date January 2024 ...
introspective7887's user avatar
1 vote
0 answers
36 views

Assistance Needed with Left Joined Custom Report

Assistance Needed with Left Joined Custom Report I have a custom report that combines two objects, Intakes (Leads) and Matters (Intakes converted to Matters), using a left join. I opted for a left ...
Shakti's user avatar
  • 11
0 votes
2 answers
67 views

Packaging Reports containing field to field comparisons

When attempting to package a report that contains a field to field comparison is shows the unique Id of the field in the metadata as opposed to the field API name. This means that it cannot be stored ...
Jack McGrady's user avatar
0 votes
0 answers
38 views

SF report formula - date

I would like to add additional column in report where function will be checking if the condition is met. Formula should check if order priority is: High and then if creation date of order is less or ...
Marek M's user avatar
0 votes
0 answers
11 views

Unique opens is zero, but total opens are 3?

I run a report about a journey send at Marketing Cloud, and for one date, I have the total opens = 3 and the unique opens is zero. How is it possible?
Tamyris Ayumy's user avatar
0 votes
0 answers
25 views

Error in graph when trying to calculate lead % change month-to-month

I am trying to calculate the month-to-month lead % change for my company. I have the created month as a grouped column and I used the following formula to calculate the % change: (RowCount - ...
rts1994's user avatar
0 votes
0 answers
31 views

Report of Accounts without Leads

Is there a way to create a Report of Accounts that do not have a related Lead? It can be done in SOQL: SELECT Name FROM Account WHERE Id NOT IN (SELECT ConvertedAccountId FROM Lead WHERE IsConverted = ...
AlwaysThinkin's user avatar
0 votes
0 answers
24 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 ...
clargan's user avatar
  • 21
0 votes
0 answers
814 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 ...
Lut's user avatar
  • 287
0 votes
0 answers
395 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
  • 532
-1 votes
1 answer
72 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
0 votes
0 answers
232 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 vote
0 answers
157 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
  • 359
0 votes
1 answer
171 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)...
Raj's user avatar
  • 1,355
-1 votes
1 answer
40 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
304 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
68 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
578 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
  • 136k
-1 votes
2 answers
95 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
2k 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
1 answer
576 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
788 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
1 answer
134 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
-1 votes
1 answer
237 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
35 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
847 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
  • 155
-1 votes
2 answers
148 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
1k 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
821 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
471 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
-1 votes
2 answers
498 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
2k 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
176 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
  • 868
1 vote
0 answers
154 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
244 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
248 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
2k 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
692 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

1
2 3 4 5