How to show incident record in report that will going to end/due date expiring?

[Nawal Kishor S2]

Hi Experts,

Hope you all doing well!!!

I have a requirement to show the incident that is going to expire by its event end date, i tried lots of thing but the outcome is not expected, please review the below screenshot and let me know if that is possible?

Report--

Incident table--

I want to show the incident--INC0010626 & INC0010527 in 1-7 days range that means these incident are going to end within this date range.....but records are not showing in the report , so how can we achieve this , if possible please let me know..!!

[palanikumar]

You can add condition as "New Event End Date"-"relative"-"before"-"7"-"Days"-"from now"

[OlaN]

Hi,

Can you check if there is some limitations on who gets to report on this field.

Should work, given you have access.

What happens if you right click on the list-header and select bar chart from the menu, and then just change the grouping from caller (or what field you select) and set it to your custom field?
Example below.

[Nawal Kishor S2]

Hi, 

here it is--

[OlaN]

Right, and as you can see, you cannot click a Date/time field and do a bar chart.
But if you click the Caller column you can, and then in the generated report, just switch the grouping to your custom field.