Questions tagged [reporting]

General questions relating to reports, but not dashboards, in Salesforce. Report formats may be tabular, matrix, summary, or joined.

Filter by
Sorted by
Tagged with
0 votes
1 answer
25 views

Trying to Create New Reporting Snapshot - But, Custom Object is not available in the List of Target Object to select from

Trying to Create New Reporting Snapshot - But, Custom Object is not available in the List of Target Object to select from. We have Accounts as a Master-Detail on that object. Could that be the issue?
user avatar
  • 1
0 votes
0 answers
15 views

Tracking overall email engagement with "DoNotTrack" enabled

Is there a way to get email KPIs in terms of opens/clicks etc. while "DoNotTrack" is activated for the entire subscriber list part of an email send out? As per my understanding, this is not ...
user avatar
0 votes
0 answers
33 views

CloudPage Data Views

i'm trying to see the opens and clicks of my landing pages in marketing cloud. I've tried creating an impression reports, but it doesn't have attributes like the ones i'm looking for. Then i've tried ...
user avatar
  • 1
0 votes
0 answers
22 views

Salesforce Dashboard Filter Options Analysis REST API returns NOT_FOUND error code [closed]

I use PostMan to verify my dashboard using Salesforce Dashboard Filter Options Analysis REST API, but the response message says that "The request resource does not exist". This is weird ...
user avatar
  • 111
-1 votes
0 answers
17 views

Same profile, same role different number of report records

2 users with the same role and profile view a sales activity report. One is a staff by title and the other is a manager. The report shows records from task and event. However, the staff sees more ...
user avatar
  • 1
-1 votes
1 answer
37 views

Finding the difference between new value and old value for amount

I have a basic opportunity field history report that's filtered so I'm only looking at changes in Amount. I want a column that shows me the difference between the new value and the old value. I tried ...
user avatar
-1 votes
1 answer
20 views

How to set formula of duplicate value in report salesforce?

I tried to make a report duplicate contact, duplicate contact happened if there is same account ID and Mobile Phone in multiple contact. in report duplicate contact, there is duplicate_contact__c ...
user avatar
0 votes
0 answers
29 views

Report on 2 custom objects in a campaign [closed]

We recently redesigned our website, and replaced the system we used to sell tickets to classes with a new one. In Salesforce, the tickets purchased via the old system are called Tickets. Under the new ...
user avatar
0 votes
0 answers
22 views

Inline Editing on Report Not Supported for Opportunity Amount or Probability (%) cells? [closed]

I'm trying to do some inline editing on an Opportunity report to update Amount and Probability (%). However, it's saying "Inline editing isn't supported for this cell". Could I have ...
user avatar
1 vote
1 answer
23 views

User receives some but not all Scheduled Reports

One of my users was complaining that he did not receive some of his scheduled reports (reports he scheduled himself with recipients either himself or himself+others). These reports had previously been ...
user avatar
  • 62.3k
0 votes
1 answer
23 views

Did something happen with the Month function?

I am trying to create a Row Level Report formula to give me the Opportunity Created Month. Below is a picture of the formula I am using. This has always worked before. Do you all know if something ...
user avatar
0 votes
1 answer
58 views

How to calculate & report on the time between two specific Stages?

I’m trying to calculate the amount of time it takes for an opportunity to move to a specific stage after being created. For example, Client A moves through the following stages: First Contact: 3 days ...
user avatar
0 votes
0 answers
26 views

Subscriber Email Opt-In/Opt-Out at the Business Unit Level via a report in Analytics Builder?

My client has several business units, and each business unit's subscription handling is configured as "Unsubscribe from the business unit" (vs. unsubscribe from the enterprise). I'm trying ...
user avatar
0 votes
0 answers
35 views

Can we track changes made via workbench?

We are working on our audit readiness and are preparing to restrict connected app access to Workbench for all profiles, except System Admins for full use and our Analysts so that they may do queries. ...
user avatar
  • 15
-1 votes
1 answer
28 views

How to just show subtotals for each column in a report?

I'm having trouble doing something supposedly very simple, can anyone tell me how I can display the record count for each column in a report? Knowing that each column is a picklist field that can have ...
user avatar
0 votes
1 answer
25 views

Sending email to record owners in a report

I have a report that contains the top 20 opportunities for a certain industry. Is there a way to automatically send an email to those specific opportunity owners on a monthly basis? These ...
user avatar
  • 5
0 votes
0 answers
21 views

Formula to calculate latest date from different orders in a report

Hey guys :) so I'm stuck here... I got a report in salesforce containing an 'Issue Date' field, and it would help me a lot if I had the latest date from different orders... I tried to create a field ...
user avatar
0 votes
1 answer
31 views

Send Reports to Non Salesforce Users [duplicate]

We want to schedule 8 reports to 15 non-salesforce email addresses every week on Wednesday. In salesforce, I can see that we cannot send email results to Non-Salesforce users. What is the best way to ...
user avatar
-1 votes
1 answer
54 views

Summary Level Formula - Sum Closed/Won Opportunities

I am using Lightning and trying to build a summary level formula field to show the sum of closed/won opps next to the sum of total opportunities for a given time period (fiscal quarter for example). ...
user avatar
0 votes
1 answer
26 views

SOQL Queries using the Rest API results are close to half that of the Salesforce reports

I have a query in SOQL SELECT+Event.Id,Event.CreatedDate,Event.StartDateTime,Event.EndDateTime,Event.Subject,Event.DurationInMinutes,Event.OwnerId,Event.Status__c,Event.Intro_meeting_summary__c,Event....
user avatar
  • 21
0 votes
0 answers
41 views

Unable to Report Events(Activities) with Direct Relation to Account via WhatId

Is there any way we can use standard reporting capability to fetch Events where WhatId is associated with an Account record ? I am able to fetch Events which are linked (in-directly) with Account via ...
user avatar
0 votes
0 answers
22 views

Can I get info of which mobile SO my subscribers open my emails?

Trying to use Datorama to track which mobile SO my subscribers open my emails with, but Datorama only tracks push regards mobile data. Is there any way I can use Datorama or any other tool to get this ...
user avatar
0 votes
0 answers
17 views

Opportunities report from campaign contacts at account level

Is it possible to bubble up contacts on a campaign to the account level and report opportunities closed at the said account(s) back to a campaign? Currently, I have campaigns to contact to opportunity ...
user avatar
  • 101
0 votes
0 answers
12 views

Create report to include top 3 opportunity wins and losses

is it possible to create a report having both top 3 wins and losses for opportunities in a single report?
user avatar
0 votes
1 answer
28 views

How to include the Account Team object's fields in a report that includes Account records

I tried using the standard report type - Account with Account Teams. But the fields for the Account Team Object related to the Accounts does not appear in the list of fields to include in the report. ...
user avatar
0 votes
0 answers
27 views

Reporting Interval Between Two Dates Within Same Column

Thanks for any and all help! This is pretty straight forward but I am failing to execute. It is simple to calculate the difference between two dates if they exist in two columns, however, in this ...
user avatar
0 votes
0 answers
48 views

Report by "My Team" even with transparent sharing rules

At the moment we are unable to use the “My Team’s Accounts” (or Opportunities) filters as seen below, when we do nothing is filtered and I believe it’s because of our sharing rules and I’m looking for ...
user avatar
  • 4,368
2 votes
1 answer
60 views

How to Navigate to particular folder of Report with Navigation button in LWC

I am trying to navigate the Custom folder (Name: Account Report) of the report with the lightning button in LWC. I am able to Navigate the home of a report by the following code. But I want to ...
user avatar
0 votes
1 answer
38 views

Can I do a Joined report on Lookup(User) and Date Fields

I have 2 objects that I would like to do a join report on. The standard Activity Object and a custom object. They both have lookup fields to the User object and a date field. Is it possible to do a ...
user avatar
0 votes
0 answers
21 views

Is it possible to set up a scheduled job to automatically move reports from one folder to another folder?

Since the Unfiled Public reports folder cannot be restricted, I was wondering if there is any way a job can be scheduled to automatically move any new reports created in the "Unfiled Public ...
user avatar
-1 votes
1 answer
74 views

Converting CSV to an APEX List [closed]

I have a csv file downloaded with 1 column listing about 3000 names. What is the simplest way to grab all these names and store them in a List to be further manipulated in Apex? Thanks!
user avatar
-1 votes
1 answer
32 views

Security setting on report type

How can I allow reporting on only one report type(there is only one custom object in this report type) for a particular profile in salesforce? All other report types should be hidden/not selectable by ...
user avatar
0 votes
0 answers
13 views

Account Conversion Rate report

I need to create a chart showing the Account conversion rate (from Account Type Prospect to Customer) by country. Tracking of the field Account Type was activated and I am using the Account History ...
user avatar
0 votes
0 answers
15 views

Question from sales guy: library lookup within an Opportunity

Preface: I'm not a developer, but looking for help. My sales org uses Lightning version -- within the Opportunity, I would like the opportunity to lookup in our Library the Close Won / Close Lost ...
user avatar
0 votes
1 answer
56 views

I have no clue how to use Datorama with Contacts Counts

Good morning, So we use Discover Report for Account send Summary, deliverability, and contacts counts, my main problem is I can't get the information of CONTACTS COUNTS on Datorama, and I would like ...
user avatar
  • 3
0 votes
2 answers
41 views

Is there an automated way to determine if the system createdby field is included in reports and which ones

Is there an automated way to determine if the system CreatedBy field is included in reports and which ones? OR do we need to do a manual review of all reports to determine which need to change? I ...
user avatar
3 votes
2 answers
300 views

Download report data having >2k records through API

I am a new bee in Salesforce world. We already have an implementation of Salesforce where we are hitting analytics API via rest client in java application to receive the report data. API: services/...
user avatar
  • 153
1 vote
0 answers
41 views

Auto-suppression reporting

We have implemented auto-suppression in our parent BU down to all BU in order to suppress email sends to Russia. This is working fine. When the system tries to send an email, it just suppress this ...
user avatar
0 votes
1 answer
65 views

Cross filter with a date not working

I'm trying to create a report showing me the accounts without contract for 2022 year I selected : all accounts created date : all time Cross filter : accounts without contracts, start date less or ...
user avatar
  • 1
0 votes
0 answers
48 views

Creating a report based on Data Extension attribute?

My company has a Data Extension which gets updated daily and it consists of for example below: Name Product Product ID Weight Jason Banana 11111111 1kg Kim Apple 22222222 2kg There will be new ...
user avatar
0 votes
0 answers
40 views

Apex to run report and cast the data to an SObject?

I have a list of report Ids that I need to run, take action on the data such as creating a record, and then send that report data to an email address. These reports all have different criteria, ...
user avatar
  • 113
0 votes
0 answers
270 views

Custom Report Type lookup field not showing in report builder

I have set up a custom report type with Opportunities which can have 1 or many assets: On the Opportunity object exists an Invoice object and in the layout properties, I've created a look up field ...
user avatar
-1 votes
1 answer
22 views

Using reporting to show field completeness

I have an object with a bunch of fields and I want to run a report that will show the total number of records and how many or what percentage of each field is complete
user avatar
0 votes
0 answers
107 views

How to build a report on objects connected by a text field?

Let's consider an example data model with two objects connected with a relationship as follows: A general request is to make it possible to build any type of report that could list Custom Objects B ...
user avatar
0 votes
1 answer
72 views

Error when sending report from sales cloud

I have been trying to send an email containing Lead Report from sales cloud. The email when received shows the message "Failed" with an error report in the body. The error states "Error ...
user avatar
1 vote
1 answer
44 views

Tally conditional column on Reports

I have a report which retrieves from X Object with 2 fields called below. The first one is XObject Name and the second is a custom date field. Problem is we need to add a tally based on that custom ...
user avatar
  • 161
0 votes
1 answer
46 views

Salesforce Lightning - Summary level formula to compute rate of installed voicemails out of eligible voicemails

I have just started learning how to write row-level formulas on Salesforce Lightning. I am attempting to create a summary formula column while only being eligible to use at most 1 row-level formula in ...
user avatar
  • 1
0 votes
0 answers
126 views

How to calculate average value for summary report?

I am building a report on user's login rate which should calculate how much times a user logged in per working days in a month, applied formula "User Login Rate" to get a login rate value ...
user avatar
  • 1
0 votes
0 answers
12 views

Reference Unrelated Report on Dashboard

I am trying to create a report that is dependent on the Case object, as well as the Einstein Bot Reports from AppExchange. Is it possible to reference a total from a report built on the case object? ...
user avatar
-1 votes
3 answers
45 views

Want to differentiate between two Date/Time fields without involvement of second

I have one scenario where I have to display cases in report whose lastmodifieddate is greater than closeddate So everything is working fine but there is one issue I have a case and I closed it. In my ...
user avatar

1
2 3 4 5
31