Count rows and columns

[sergio0592]

Hi all,

I'am facing an issue and can't understand what i have wrong. I have a chart (CHART 1 in the snaphot below) with for each Day and Hour the time avability (0 to 60 min) of employee.

What i'm trying to achieve is to count the number of employee with 60 min as time avalility (number of rows) and the number of columns (corresponding to their qualification) with 60 min.

It's ok in the chart 2 for most part of hour, but for some i Don't have the real number. Qvw sample in attached file.

Thanks for your help

[tresesco · Accepted solution]

Try exp like:

Count(DISTINCT if(Aggr(Sum(DISPO),DT, NUM_TH,ID_AGENT,ID_EMPLOI)=60, ID_AGENT)) 

and

Count(DISTINCT if(Aggr(Sum(DISPO),DT, NUM_TH,ID_AGENT,ID_EMPLOI)=60, ID_EMPLOI)) 

 

[sergio0592]

Perfect, thanks!