NANO Iot BLE RSSI erratic

As you are discovering, RSSI measurements are nearly useless. They depend on distance, transmission power, relative antenna orientation and the presence and orientation of nearby reflecting and absorbing objects.