set expression

[yadav_anil782]

Dear  Community,

i'm using this expression  for count the user login time on time dimension  =count([Login Time]) and result is showing with hole day  user login .

  i need  if user login 10 times in a day then count should be not reflect 10 it should be reflect  "1" for hole day. and i wants to show this  user login count on time dimension (year,month,day)

i attached my excel sheet for data reference , plz help if anybody can help in this .

[yadav_anil782]

Dear All,

i applyed the all suggestions but this issue still not resolved .

now plz suggest to wright group by script , may be it can work-

xx_login_rev_view:

LOAD USER_NAME,

     USER_ID,

    date( LOGIN_TIME) as LOGIN_TIME,

  LOGIN_COUNT

FROM

(qvd);

now i want  group by -"USER_ID"  for " Login_TIME "

so date_time  can be group  day wise