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-events
I 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 month
Do 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 would like to know your thoughts on that.
Thanks in advance!
Best answer by michalView original