As we have a limitation on nested objects for aggregation and searches in siren, Need to know how to handle the nested objects.
Say for example you wanted to do a pie chart of gender. Gender is stored as an answer for Question 2.
You create a pie chart with the field answer.valuestring (which holds gender) but when you add that field to the pie it returns answer.valuestring FOR all questions.
Add a filter to the report - where item.linkID=2
The filter has no impact. Siren cannot compute the data . Even with a filter applied it shows on screen the results from every single question not just Q2.
Interested to see other than flattening the indices approach.