Hi,
I have an table which contains fields type = Duration. I created data visualizations related to this field inside the table and I noticed the data seems to be incorrect. Here are the attachments
My data visualization only have these configurations:
- Data Source: All Incidents records
- Metric: calculate average value of my duration field
- Group by: Assigned To
- Trend by: Monthly by field "Opened"
As you can see the chart only shows up to Aug/2025 but in my list there is a record from October 2025 in the below images. Why INC0000601 not showing on the chart ? Am I configuring something wrong which leads to this incorrect data ?
