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!
Best answer by BorisView original