Closed asset tasks report

[Rebecca Totzke]

Hello, 

I created a report to show tasks opened in the last 7 days .  These open by a business rule running at a specific time so all are created with the same date.  So I can easily see on feb 1 ## of asset tasks were created for a specific device type.  But I am struggling to show the ## of asset tasks closed on feb 1 (lumped in days) because the closed date for each is uninque including the timestamp the asset task was closed.  Is there a way to report all the asset tasks that were closed on a specific day without breaking it down by the time the tasks were closed on that day. 

[Abhay Kumar1]

@Rebecca Totzke 

If you are creating report under report menu, then filter should be picking just date regardless of time,not sure how you are creating but alternate option i can think of using operator 'at or after' and 'at or before' where you can mention starting time and end time.

Hope this will help.

[shivangi k]

Hi @Rebecca Totzke ,

Do you want report of closed tasks just based on date and not time?

Regards,

[Rebecca Totzke]

Yes.  I wanted the report to mirror what I had for Opened tasks (pivot with device type and date opened).

But becuase the closed time contains a time stamp I get entries for 2-1-2023 12:45, 2-1-2023 1:00, 2-1-23012 2:00 etc.  And I want all of the ones closed on a day to show for that date, not broken down by time. 

[Abhay Kumar1]

@Rebecca Totzke To achieve this there is only one option use function field and create a field which converts closed (datetime) into date with a name, then you can use in report.

Otherwise OOB options allow us to create trend report type but this just allow month/week by.

I will suggest try function field or go with Performance analytics.