Count the days online

Question & Answer
1

image
Can you help how to count the total days that person log in. So technically it should only be 10 not 13 because I am just counting the days.

2

image

3

hi @danielreyes3rd

First you need to convert the hour_period_ts into a date instead of a string (or datetime). Once you do that you can then use the newly converted date in a calculated field like this:

countOver({Name}, [DATE], POST_AGG_FILTER)

Hope it helps,
GL