Forum Discussion

theitguy's avatar
theitguy
Icon for Helper I rankHelper I
8 years ago
Solved

Find Entries in Time Period

Hey,   I would like to measure a pretty easy thing, but at the moment I do not know how to start. I would like to calculate how many users haven't created any sessions in the first 30 days after th...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Seems like you would get 2,3 and 5 as not having any sessions. Regardless, you should be able to use EXCEPT function.

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

I may be misunderstanding the data but I was thinking that if you did an EXCEPT on the ParticipantID columns from the two tables that you would have what you needed. But, again, I may not fully understand the entire data set.

theitguy's avatar
theitguy
Icon for Helper I rankHelper I
8 years ago

Hey Greg_Deckler,

I gave it another thought and I think you are right. I guess, I had a wrong mental model.

  • theitguy's avatar
    theitguy
    Icon for Helper I rankHelper I
    8 years ago

     Hey Greg Greg_Deckler,

     

    I needed some time to think about it. I have also changed the data a bit to make it more clear.

    What I want is to select a point in time (via a date slicer) and then I want to see the amount of leaners who have made progress in their first 30 days. Given the amount of all learners, I can then calculate the percentage. The same I am wanna do for 60 and 90 days after their hire date.

     

    So, if I check the first 30 days, I would expect to get 2 (Participant 1 and 4), for 60 days I would expect to get 3.

    Maybe this is going into the same direction as Set-FILTER-value-with-variable