I have a form with cascading select on three levels (type, category and code) using choice_filters. I want to create a report with those three fields to visualize the submissions. I see only the first layer of the cascading select (type) as available fields to use in the reports. I don’t see the other fields so I can not select them to visualize those fields.
Steps to Reproduce
Create a cascading select set of questions
Try to create a report with all the fields from cascading select
Observe that this is only possible for the first top-layer field in the cascading select
Expected behavior
Ability to select every field in the report builder in Kobo.
Actual behavior
Only able to select the first field of cascading select in Kobo.
Welcome to the community, @Daan! Thank you for bringing this to our attention. Could you also share with us a screenshot of the issue? That would be very helpful for us to start investigating the issue.
Thank you for sharing the screenshots, @Daan! Refresh your page and you should be able to upload the sample XLSForm that would also help us with testing your issue.
In your XLSForm, I found an error in the cascading select setting for the question code“observation,_perception_or_belief”—there is an extra comma (,), which prevents the cascading function from working correctly for the “Belief or perception about the disease” category. I have fixed this issue in my uploaded file.
After submitting about five cases to the server, I was able to generate a report, including the Feedback Category and Feedback Code. Please check the screenshot and try again after submitting some cases.
Thank you very much @naylinsoe ! I was expecting it to be because of the cascading select. Turns out it was because of a small comma.. Thanks a lot for your help.
