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 .

[mayankraoka]

Hi Anil,

Please try this:

aggr(count(distinct([Login Time])),USER_ID,LOGIN_TIME)

Regards,

Mayank

[rubenmarin]

Hi Anil, I don't kwon how you want to show the data, please check attachment. To count differente dates you can make a count(DISTINCT ...)

[mayankraoka]

Hi Anil.

pfa.

Regards,

Mayank !

[yadav_anil782]

Dear Ruben,

i want short count on  day basis only , if i login 10 times in particulate day then it should be consider only "1" 

[Anonymous]

In that case you need to change your dimension from Time to UserID/Name etc.

If you are taking Time Dimension, if this time match to your expression value it would return 1.

So use User Dim.

[rubenmarin]

Hi Anil, have you checked the attachment? It only counts 1 by each user/day, If you want to discard the user you only need to remove the user dimension in the attachment.

[ankitaag]

Hi Anil,

In your excel you have 2 fields Login time and LOGIN_TIME. Can't you take LOGIN_TIME in count as count(distinct LOGIN_TIME)?

Thanks and Regards,

Ankita

[Anonymous]

Anil,

Use scatter chart with two dimension.

One dimesion wud be: USerID

2nd wud be: Time Dim

Expression wud be: count(distinct(LOGIN_TIME))

[jafari_ervin]

you can use this expression  count( distinct date([Login Time]))