Forum Discussion

antlufc's avatar
antlufc
Frequent Visitor
2 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
2 years ago

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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

antlufc What is the relationship? As in, what forms the relationship?

  • antlufc's avatar
    antlufc
    Frequent Visitor
    2 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
      2 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.

      • antlufc's avatar
        antlufc
        Frequent Visitor
        2 years ago

        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.