
Hello,
Got some questions regarding Lightning report builder:
- Will it be possible to create date filter using date field as value (Ex: Create date equals to Closed date) ?
- Did a report create with lightning report builder can be executed in Salesforce Classic ?
- Will it be possible to bucket non-picklist field ?
Thanks.
5 comentários
Hi @BERNIS NYONKWE ++
@Aiyaz AhmedCurrently field to field comparison is not supported in reports but I have heard its coming not sure on when its coming, meanwhile, please upvote and promote the below idea, until then the only alternative is creating a formula field of checkbox type that return to true when both fields are same and use that field in the filter criteria
Assuming the Closed Date is a Date/Time field, the formula will be as below, formula return type checkbox
DATEVALUE(CreatedDate) = DATEVALUE(ClosedDate)
use the insert field button to select the field API Name of ClosedDate
Link to the Idea
https://success.salesforce.com/ideaView?id=08730000000BrHAAA0