If you are sat in the centre seats in the cabin then it can feel quite warm, if you are in a window seat it can be a lot cooler due to the proximity to the aircraft skin and the outside world (the sidewall panels can get quite cold after 'cold soaking' for several hours plus)
Back in the old days when perhaps more "analogue" and "artful" skills were required to operate an airliner and Flight engineers were part of the team the cabin crew would often come up and ask the FE to drop the zone temps at night after the meal service. The thinking behind this was that it would encourage the pax to sleep and they wouldn't keep pestering the galley slaves for drinks all night. This however just made it very cold for some of the pax so the FE I knew turned the temp down for 5 mins then turned it back up again! Also the flightdeck on the 747 classic could get quite nippy on a long night sector, even with the temp selected up, and "frost" would form on the uninsulated windowframes around the two windshields!