Problem in multi selections in years

[Anonymous]

I want display worked hours per EMP_ID  month wise , year wise and multi selection of months and years alone.

employee worked hours enter daily basis

here condition is worked hours <4 is available,>=4&<8 is partially available,>=8 is occupied.

could you please tell me script level

Regards

Yuvaraj

[MK9885]

Simply add

Month and Year to your Multi Box chart

User can select single month or multiple..

And the data will change according to the user selection.

Is this what you need?

[vishsaggi]

What is your expected output, you want a new field to display if an employee available or occupied based on worked hours? IF Yes,

Then in your script write like

LOAD *,

     IF(WorkedHours < 4, 'Available', IF(WorkedHours >= 4 AND WorkedHours < 8, 'Partially Available',

             IF(WorkedHours >= 8, 'Occupied'))) AS Availability,

     Year(Sheetdate) AS Year,

     Month(Sheetdate) AS Month;

LOAD EMPID,

     WorkedHours,

     Sheetdate

FROM

[WorkedHours.xlsx]

(ooxml, embedded labels, table is Sheet1);

Let us know if this is what you are looking for.