New answers tagged

0

The one case that I can see where your (Abishek Saxena) answer won't work is if you experience this 1 second difference between LastModifiedDate and ClosedDate on a minute boundary. A difference between those two fields should be rare enough as is, and a difference across a minute boundary should be rarer still. So with that in mind, it may not make sense to ...


1

I have create the custom formula and has solved the problem. IF( AND( DATEVALUE(LAST_UPDATEONLY) == DATEVALUE(CLOSED_DATEONLY), HOUR(TIMEVALUE(LAST_UPDATEONLY)) == HOUR(TIMEVALUE(CLOSED_DATEONLY)), MINUTE(TIMEVALUE(LAST_UPDATEONLY)) == MINUTE(TIMEVALUE(CLOSED_DATEONLY)), SECOND(TIMEVALUE(LAST_UPDATEONLY)) != SECOND(...


0

Since you are comparing two "datetime" fields in your report, it is taking into consideration the time. Way to get around this will be to compare 2 date fields instead. Since lastmodifieddate is a datetime field, you can use a formula to only store the date and then compare that with your closedate field.


2

You can use two filters, such as "Created Date greater or equal Jan 1, 2022 AND Created Date less or equal Feb 28, 2022", or you can use a relative date filter, such as "Created Date equals NEXT 2 MONTHS" or "Created Date equals THIS MONTH, NEXT MONTH".


3

That's because you have zero standard filters on that report. Standard filters vary by report type. For example, standard filters for reports on the Opportunity object are Show, Opportunity Status, and Probability. Based on your screenshot, Show Me is scope which you can see in the Report metadata. You can get this with getScope() Defines the scope of ...


0

This is untested but under lightning you can now add row level formulas to a report. https://help.salesforce.com/s/articleView?language=en_US&type=5&id=reports_formulas_row_level_add.htm Don't see why you could not just write a formula that returned an empty string and repeat that process for the number of blank cols you wanted to insert.


0

I have feel the difference of your Duplicate Rule and Report object relationship, So I think that may be the cause you have missed the duplicate accounts in your account report. In your Duplicate Rule - You're said the matching rule as the same name having accounts are possible duplicate in your org. But in your Report object relationship you have taken the ...


1

As mentioned in the comments, reports can be used across many different dashboards. What you're looking for can be easily achieved with a SOQL SELECT count() FROM Report WHERE Id IN (SELECT CustomReportId FROM DashboardComponent The above will give you the actual number you're interested in: # of unique reports on dashboards In your existing report you can ...


Top 50 recent answers are included