colour visualization can remove last record