DataEditor Count and then Filter in counted Variable

BCFi — Tue, 21 Jun 2022 12:07:29 GMT

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 !

Re: DataEditor Count and then Filter in counted Variable

Mark_Little — Tue, 21 Jun 2022 12:45:53 GMT

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;

topic DataEditor Count and then Filter in counted Variable in Connectivity & Data Prep

DataEditor Count and then Filter in counted Variable

Re: DataEditor Count and then Filter in counted Variable