Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
There is an expression with me which to display with a Image/Symbol now what i want is to display is the count where it is displaying the image//Symbol Following is the expression
if
(
count
(
{<
CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},
InOut={0}
>}
InOut
)
<>
count
(
{<
CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},
InOut={1}
>}
InOut
)
,
'qmem://<bundled>/BuiltIn/minus_r.png'
)
Something like this
Try this
Sum(Aggr(if(count({<
CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},
InOut={0}
>}InOut)
<>
count({<
CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},
InOut={1}
>}
InOut ),1,0), Location, DepartmentName, EmpName, tran_date))
Expression looks good, What is the issue? Have u changed Representation from text to image?
Hi Anil ... This expression will display the image i want but my intention is to display the count.
lets say in the below image it is displayed '-' symbol in red now i want to show the total count of Red highlighted Minus Image count .
Great, Would you able to share sample?
Anil Find the File attached.
Can you check this for first one, Whether the result same as you expected, Expression here
count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={0}>}InOut)-
Count(Aggr(if(count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={0}>}InOut)<>
count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={1}>}InOut),1,0),Location, DepartmentName, EmpName, tran_date))
Anil ... Shared File could you check with this Count.
Don't we already see all the minus signs with 1?
This Giving some Wrong numbers Anil.
I will explain you little Clearly Exactly in previous image it is displaying entries of access not done properly by an employee lets he is IN and Out in ratio 3:2 then it is displaying that Minus symbol in a day like that an employee access who are not punching properly due to tail gating and some other reasons
Note Where Work Station Gate entry Should be Ignored Due to only in access can be swiped but not the exit swipe avail in that gate.
Attached is a sample to explain you
Here shown an employee in and out entries are not proper Check this On 9th jan entries are like this
in order to track this entries How many days an employee has done this
Hope i explained you clearly.
Need to show the count of all the Minus Symbols of an employee this shows how many days he i irregular in punching properly