Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please see my data table below. I want to create a variable that counts the number of 'ID's with days less than 90. When I create the variable on my own, it gives me 6 as the answer, but really the answer should be 2 ID's. I know I need to use the distinct function, but I just cant get the formula to work. How can I accomplish this? Thank you!
ID | days |
1 | 5 |
1 | 5 |
1 | 5 |
2 | 20 |
2 | 20 |
2 | 20 |
3 | 100 |
3 | 100 |
3 | 100 |
HI.
I've created a new discussion in the following group and with this title
this is correct count function will count all the values <90 and with distinct used so it will count only unique values in a set analysis
= Count(DISTINCT {<days = {"<90"} >}ID)