Forum Discussion

theitguy's avatar
theitguy
Helper 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.

theitguy's avatar
theitguy
Helper 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
Helper 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