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
date dimension - which provides the date linked to fact events via date key
fact events table - which provides the MQL latest date, key and date key which links to date dimension based on the date an event happened and dim events via the key
dim events - which contains the stage name which is linked to fact events via the key.
Greg_Deckler
Community Champion
Community Championantlufc So the dim events table also has a date so you know what stage a key was in on a specific date?
Greg_Deckler - no dim events only has the stage name.
The date where the specific event has happened is in fact events.