Forum Discussion

aabi's avatar
aabi
Helper I
2 years ago
Solved

Counting Unique Values Level based on last timestamp

Hello All   I have been trying but with no effect to count a the numbers of users that are on a certain level. But only the MAX of a certain time stamp   As a sample the table below   Custom...
Need Help
  • some_bih's avatar
    some_bih
    2 years ago

    Hi aabi please create another column to check true false last date for customer

    True False LastDateForCustomer = Sheet1[MaxDatePerCutomer]=Sheet1[Timestamp].
    After that create overvies as shown on Output (slice True)

    Did I answer your question? Kudos appreciated / accept solution!

     

     

    Output

     

TomMartens's avatar
TomMartens
Super User
2 years ago

Hey aabi ,

 

what is the expected result based on the sample data you provided?

 

Regards,

Tom

aabi's avatar
aabi
Helper I
2 years ago

Hi TomMartens 

 

Well my sample might not be the best, but the results should have been 

Level 1 Count = 1

Only UserID 2222, is level 1 on the last date.

I would also have the same formula as "level 2 count" which should be 2 (UserID 1111 and 5555)