Forum Discussion

antlufc's avatar
antlufc
Frequent Visitor
3 years ago

Different Dates based upon 2 different columns

The table below shows MQLs by latest date and latest event flag.  I would like to show the volume of MQLs that are Not Accepted or Achived using the MQLs - latest date.    So in my below example...
antlufc's avatar
antlufc
Frequent Visitor
3 years ago

Greg_Deckler  - date key based on event date from the fact table to date key in the date dimension.  The event date could be associated with events prior and post the MQL latest date

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

antlufc I'm not quite following this. So you have a Date dimension and that includes what the Stage is for each Key based on which Date? Maybe post a picture of your data model or at least the relevant tables. I'm not understanding how you are arriving at the correct Stage for a specified Key and Date.