To GoodData homepage

Topics started by niko

2 Topics

N
nikoParticipating Frequently
asked in Data models

Using "event" dataset

Hello,I found an interesting article on your help site regarding analysis using dates: https://help.gooddata.com/doc/enterprise/en/data-integration/data-modeling-in-gooddata/if-too-many-date-dimensions-try-eventsI think it will suite my needs as I need to be able to slice data using dates that have different meaning. The scenario described in the link only presents a case where the event is related to single dataset, in my case this is quite different as the event has to be connected with two datasets (which in the ends happens to create so called “alternative paths”). I wanna make sure the model above will be valid or maybe there’s a different approach to the problem that won’t result in alternative paths? Example report I would like to build using those datasets:Report showing # of projects were in a given phase month by monthDo you think the approach above is OK? I’m pretty sure building right model is really important before I can proceed with data transformation on my side, so I w

9
N
1 year ago
N
nikoParticipating Frequently
asked in Data models

Analyzing "multi-select" values

Hello,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 TypesField Choices: Panel 1, Panel 2Report: 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!

3
Boris
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings