Create Dynamic filter on report

[zee15]

I am generating a report that displays closed tasks occurring between 12 PM to 9 PM on a daily basis. However, I encountered a challenge when attempting to filter the data based solely on time.

The issue arises when selecting "closed between today" as it also selects the date, whereas I wish to filter the data exclusively based on time.

I also check that if we I could use "closed_at greater than" or "closed_at less than" but greater then or less then is not visible when i choose closed_at field in the filter.

Could you kindly provide guidance or support on how to refine the filter criteria to achieve this goal? I appreciate any insights or instructions you can offer to streamline the report generation process.

[Dr Atul G- LNG]

Hi @zee15 

You the trend operator 

Attached is sample, create 2 condition, 1st after 12PM , 2nd before 9 AM

[zee15]

Hi @Dr Atul G- LNG 

Thankyou for the reply. I tried this and that worked but there is a issue it display all the records which are closed between 12 to 9 even 2 month ego's records but i want only today's records for example today is Thursday and there are 5 closed record so it should display only 5 records and same for tomorrow

[Dr Atul G- LNG]

Hi @zee15 

Try add Today as well

with AND condition.

[zee15]

yes I tried but that didn't work check image "empty"

I closed one task check image "recent_record" but that is not visible in the filtered list. it display other records check image "fetch_record"