I think I need a guidance on the data modeling issue.
In our app we have multi-select fields that we want to analyze in GoodData. From the user perspective it's possible to fill out some forms with fields of different types, e.g. text fields/numeric fields and select fields. The select fields are basically single select and multi select ones. All the fields are custom (means they are a separate entity in the database and can be created/deleted/modified, they are NOT a static attribute).
From the database perspective we have a model called “Scoop” which can have many “Fields”, and those “Fields” can have multiple “Choices” if the field type is multi-select. And now we want to analyze such fields and their values. Example:
Field: Panel Types
Field Choices: Panel 1, Panel 2
Report: Show % of scoops with Panel1 and Panel2 vs. those with just Panel1. (pie chart)
Is that possible to achieve?
If you need any more details just let me know.
Thanks in advance!