Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear all
how are u today, now i have some problem, if u have time, would u like to help me, thanks
current , i have data
name joindate termindate status
rika sang 2010-12-12 2014-12-12 In-Active
andrias 2011-12-12 2014-12-12 In-Active
anita 2012-12-12 2014-12-12 In-Active
ambra 2010-12-12 2013-12-12 In-Active
andrian 2014-12-12 null Active
so i want to know about Using 2 conditional ( date and Status)
1. count joindate person every year
2. count termindate person every year
i using this code for item (2) --> count({<[e_status]={'In-Active'}>} e_status )
- but i want to using 2 condition, is termindate. i don't know , how to write in expression
would u like to helpme
thanks
no, i don't
i 'll try, thanks
Hire:
count({<[e_status]={'Active'}, Year={2014}>} name)
Terminate:
count({<[e_status]={'In-Active'}, Year={2014}>} name)
about Hire
how know , if i want to know count join date, maybe one of person in this year (2014), has resigned
( based on my data)
Hi,
Try like this
Script:
Data:
LOAD
name,
joindate AS Date,
Year(joindate) AS Year,
status
FROM DataSource
WHERE status = 'Active';
Concatenate(Data)
LOAD
name,
termindate AS Date,
Year(termindate) AS Year,
status,
joindate
FROM DataSource
WHERE status = 'In-Active';
Regards,
Jagan.
i try and success, thanks