Forum Discussion
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...
Greg_Deckler sorry forgot to mention stage name is in a different table to latest evcent flag however they linked via a relationship
- Greg_Deckler
Community Champion
antlufc What is the relationship? As in, what forms the relationship?
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
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.
