Forum Discussion

adealboran777's avatar
adealboran777
Frequent Visitor
8 years ago
Solved

Date and Two Table

Hi!   Let's see if somebody knows how to do this.   I have two tables:   The first one records several interactions with an app, which can be of Type A or B, during a period of time. Date. I...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    So this is going to basically look like:

     

    Interactions Measure = 
COUNTROWS(FILTER('InteractionsTable',[Interaction]="A"))


Users Above Threshold Measure = 
COUNTROWS(
    FILTER(
        SUMMARIZE('UserTable',[UserID],"__Interactions",[Interactions Measure]),
        [__Interactions] >= 5
    )
)

    For users with 5 or more interactions.

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

So this is going to basically look like:

 

Interactions Measure = 
COUNTROWS(FILTER('InteractionsTable',[Interaction]="A"))


Users Above Threshold Measure = 
COUNTROWS(
    FILTER(
        SUMMARIZE('UserTable',[UserID],"__Interactions",[Interactions Measure]),
        [__Interactions] >= 5
    )
)

For users with 5 or more interactions.

  • adealboran777's avatar
    adealboran777
    Frequent Visitor
    8 years ago

    Thank you!