Greetings, I did add all fields in list format to a built assessment tool on CommCare but the downloaded data on excel are received in form of dotted lines as data for empty fields (---). This has caused my team a lot. Please kindly help me out. Many thanks in anticipation for solution.
Fields in list format downloaded data on excel are received in form of dotted lines as data for empty fields (---)
Yeah I understand how that can be annoying. but think of it this way, other ways of representing a "null" value are:
4- " "
using --- is because you need a specific way of determining if a question was displayed to the enumerator and left without an answer, vs, answering with a blank, vs answering with a space or a zero, or a default value of some kind.
I am not aware of a way where you can change that from the exporting side, but you can always perform a replace in powerbi or power query