Time format Assigning to Slider Object

[kakani87]

Dear All,

I'm having data like Date , Emp, IN and OUT timings

now I want to display Employees IN time >10:00:00 to highlight and this is shown but this should be assigned to a slider where user can make changes IN time from 9:30:00  to 10:30:00

Date | Emp | IN | OUT

with min signIN time and max signOut for max date using set expression.

Able to give 9,10 like numeric values in min and max slider values how to set the range in time interval

Shared a Sample Document.

I appreciate the Response for this post 

[sunny_talwar]

Set analysis syntax is not right... try this

=Min({<tran_date =  {"$(=Date(Max(tran_date)))"}>}SignIn)

[kakani87]

Sunny When the same set expression added into my chart then it is behaving like this  with no data

[sunny_talwar]

Not sure what you are trying to get, but may be one of the two

1) =Min({<tran_date =  {"$(=Date(Max(tran_date)))"}>}SignIn)

2) =FirstSortedValue(Aggr(Min(SignIn), EmpName, tran_date), -Aggr(tran_date, EmpName, tran_date))

[kakani87]

I'm trying to display as per the requirement Min SignIN and Max SignOut for monitoring the emp In and Out timings

=FirstSortedValue(Aggr(Min(SignIn), EmpName, tran_date), -Aggr(tran_date, EmpName, tran_date))

This is displaying the values properly but what my question is can we display as on date values like you suggested me with a set expression in the above one because that set expression returns no data as shared you the screen earlier.

Apart from this first sorted value returns the min value is there any thing for max value like last signout

[sunny_talwar]

Share the application as I have no idea why it isn't working for you, when it is working for me

[kakani87]

Sunny  PFA.

[sunny_talwar]

I open your dashboard and see this

What am I missing? I don't see any nulls?

[kakani87]

All this is with the help of you but can we display only max date i.e jan 1st data only apart from all days data

[sunny_talwar]

I understand the problem now... you tran_date is actually in number format, you only gave it a date format with the chart properties... Set analysis is very sensitive to formats, so when we used this

=Min({<tran_date =  {"$(=Date(Max(tran_date)))"}>} SignIn)

The comparison was done from Num to Date... which won't work... but this will

=Min({<tran_date =  {"$(=Num(Max(tran_date)))"}>} SignIn)

[kakani87]

Thank you very much Sunny