I have 3 data sets from Jira where one data set driven is by Updated date, 2nd with Created Date, 3rd with resolved date. Facts are derived from 3 sets, so could some one pls guide me to create a common date from these 3 data sets and best approach to design a data model.
note: Each data set has all these 3 dates i.e Updated, Created and resolved and also few common columns between them
thanks Peter, I have tried this approach but still there was data discrepancy as my key was associated with different dates. for example: StoryID &'-' & EpicID was my key for all these data sets but there were cases where same key is associated with different dates