To GoodData homepage

Replies posted by niko

5 Replies

N
nikoParticipating Frequently
asked in Data models

Using "event" dataset

Hi @michal ,This explanation is really great, that clears up a few things. I will try this in upcoming days and let you know, but looks really promising!Thanks to everyone involved 

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

Using "event" dataset

Hi Niko, Could you elaborate more on the reporting you'd like to achieve, describe relationships between datasets and its field and maybe provide some specific sample data? -Jan Hey Jan, thanks for response. What I want to achieve is e.g showing # of projects that entered given phase at specific period. The Phase Event would have it’s type f.e “entered” and “left”. From the database perspective in our app it looks similar to this: Generally the phase events are historical data for given project and project phase.The data could eventually look something like thisEvent ID Project ID Project Phase ID Event Type Event Date 1 1 1 enter 01.01.2020 2 1 1 leave 01.01.2020 3 1 1 enter 01.01.2020 4 3 1 enter 01.01.2020 5 4 2 enter 02.01.2020 Expected results:# of projects entering phase Phase name Month 2 Phase A 01.01.2020 1 Phase B 02.01.2020  Hope that clarifies the problem a bit, thanks!

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

Using "event" dataset

Hello Niko, my apologies for delay getting back to you. I was noted you discussed this on office hours. This could work if you remove arrow from Project dataset to Project Phase Event, change orientation of the arrow to be pointing from Project dataset to Project Phase dataset and add primary key to the Project Phase Event. Does this solution works for you? -Jan Hey Jan,I tried this approach but I’m not sure if it’s what I wanted. Basically Project Phase is a template which holds many projects, if I change the direction in the end it won’t give me the same amount of project phases and the results will be different (because I will upload only the phases that actually have any projects). Let me know your thoughts.Thanks

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

Using "event" dataset

@Jan Kos hey Jan, thanks for answerCould you maybe provide an example of how could I simplify it to be able to use it with explicit lifting?Thanks!

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

Analyzing "multi-select" values

@Boris thanks a lot Boris for that explanation. I just wanna ask about option 2, because in my app I can have a lot of custom choices which I believe would not be suitable if I choose this option? Would that require creating separate dataset and putting there placeholders for that? At the moment it’s not a problem to make data transformation on my side, since I’m uploading custom CSV to work with GoodData.Thank you

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