Current Week Selection

[#1]

Hi,

Below is my expression for current week data.

If((LeaveStatus='Absent' or LeaveStatus='Present'),

Num(Count(Distinct {<AttendanceWeek = {$(vCurrentWeek)}>} EmpBasicInfoID),'###')

)

But if i select any other week its not showing data. I need to show current week by default and on selection it should show respective weeks data.

Regards,

Keerthi KS

[PrashantSangle]

Hi,

Can you share vCurrentWeek expression????

Regards

[PrashantSangle · Accepted solution]

Hi,

If you are using week(today()) then replace it with week(max(datefield))

Regards

[#4]

using week(today())

[#5]

For Month Should i use Month(max(datefield)) ?

[PrashantSangle]

Yes

[#7]

How about for Average time function.

My expression is Interval(Avg(OutTime-InTime),'hh:mm')

It should show current week by default. and on selection it should show for other week

[PrashantSangle]

Hi,

did not get it can you explain little bit more???

Avg(OutTime - InTime)      ----- Give you average time between OutTime and InTime.

Regards

[#9]

It gives average time between

If i select week then it will take average of that week.

if i take month it shows average of that month.

By default it should show average of current week.

[PrashantSangle]

Hi,

set analysis inside AVG()

like

avg({<week={"=$(=week(max(datefield)))"}>} OutTime-InTime)

Regards