function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Murali Krishna 381Murali Krishna 381 

Reports and Dashboards concept

Report that can track the total number of opened and closed cases Create a report to track total number of opened and closed cases. Ensure elapsed time on cases is displayed in the report in days User should be able to see the report based on grouped by status Create dashboard to share a visualization of its data with others Make sure the dasboard is added to the Home Page Also the dashboard chart should be a funnel one   
this is the criteria in this criteria i stucked with elapsed time thing
how to create a report  like row formula or column formula for elapsed time 
Best Answer chosen by Murali Krishna 381
SwethaSwetha (Salesforce Developers) 
Hi Murali,
Create a text-based formula field like  
IF(FLOOR( (NOW()- CreatedDate)) > 0,TEXT( FLOOR( (NOW()- CreatedDate)) ) & " days ", "") 
& IF(FLOOR( MOD( (NOW()- CreatedDate)* 24, 24 ) )>0,TEXT( FLOOR( MOD( (NOW()- CreatedDate)* 24, 24 ) ) ) & " hours ","") 
& TEXT( ROUND( MOD( (NOW()- CreatedDate)* 24 * 60, 60 ), 0 ) ) & " minutes "
& TEXT( ROUND( MOD( (NOW()- CreatedDate)* 24 * 60*60, 60 ), 0 ) ) & " seconds"
It will display the value like this:
19 days 13 hours 7 minutes 53 seconds

You can drag and add this field to your report.

Reference: https://salesforce.stackexchange.com/questions/177219/formula-fields-date-and-date-time-case-elapsed-duration

Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you