Why is data in Summary box ED> Trends > Pod Trends different from the calculation from an extract from Av. LoS by Arrival Date chart?

The summary Excel calculation from Av. LoS by arrival date chart is not based on the same information as the summary metric box.

The summary metric box is the accurate information to get the correct average.   The summary box looks at the entire day when there might be patients straddling midnight.

The chart 'Av. LoS by arrival date' shows information based on patients who departed that day.