Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am trying to do an anlysis and prepare the data in the data editor.
My problem simplified:
There are several tasks and I am counting the tasks for each department. Now there several Sub Tasks for this department. For example all departments need to following steps:
identify requirement
satisfy requirements
document solutions
Now I want to count the total tasks of Department X. So I will do:
count ( if ( @Department = 'X')) as Tasks_X
The next step would be to unroll the tasks for each departmend. So i am doing the following right now:
count if (@Department = 'X' and @Task = 'identify requirements') as Tasks_X_identify.
My real world example is a bit more complex because i have to apply much more filters.
The question now is. As I already filtered for Tasks_X. Can i do something like:
IF Tasks_X=TRUE() AND @TASK = 'identify requirements' as Tasks_X_identify.
I hope it is somehow understandable...
Thanks a lot !
You would need to do an additional load and either keep it separate or join it back
LOAD
Department,
Count(Task) as TaskCount
IF( Task = 'identify requirements',Count(Distinct Task)) as "identify requirements count"
...
Resident Table
Group by Department;
You would need to do an additional load and either keep it separate or join it back
LOAD
Department,
Count(Task) as TaskCount
IF( Task = 'identify requirements',Count(Distinct Task)) as "identify requirements count"
...
Resident Table
Group by Department;