Bring the allocation level in day wise

[Anonymous]

Hi All,

In below image I have a allocation level in date wise so, I need to use Pie chart for allocation level to find count of how many employees are occupied ,Partially occupied and Available  , Allocation level as IF( worked_hours>7, 'Occupied',  IF(  worked_hours>3 and worked_hours<8, 'Partially Occupied',  IF( worked_hours<4,  'Available' ))) so What can I give as dimensional and expression in Pie chart to show day wise allocation

[Anil_Babu_Samineni]

Instead of Pie chart, I would go Funnel chart for this

Dimension as

IF(worked_hours<4, 'Occupied',  IF(worked_hours>3 and worked_hours<8, 'Partially Occupied',  IF( worked_hours>7,  'Available' )))

Expression what you want to calculate

may be ---- Sum(Measure) or Count(Measure) {Measure may be -- ProcessTaskID / ResourceId}

or you can try same with Pie chart if you required to show.

[Anonymous]

ok thanks I will try it

[yoganantha321]

Hi vijay,

kindly follow the below expression:

=count(Aggr(if(round(sum(worked_hours)/Count(sheet_date))>7,EmployeeID),EmployeeID)) // Occupied

Repeat it for remaining two....

I think it will be useful