real-time count by group

[#1]

Hi !

I found some problem with this simple task.

I have table with 2 dimensions:

1. gruppa

2. otveststv

and then i try to do:

1. Add expression count(tasks)

2. Add condition:  if(count(tasks) >= 2,1,0)

3. Now i want to count: how many otveststv in each gruppa is good by condition

Please see attached files.

How can i get something like this?

Please help if you can

[spividori · Accepted solution]

Hi!

See the attached example.
Hope this helps.

Regards.

[#3]

Thank you, Sandro!

This is helpful, with agrr function i could find whou many tasks good by condition.

Now i have this table ( third table in image):

but in result chart i need table with:

gruppa, count types (good by condition), count tasks (good by condition), Avarage by condition = count tasks (good by condition) / count tasks (good by condition)

in excel its look very simple:

but in QV i can't get this final table.

[#4]

i found it.

[spividori]

Congratulations! I'm testing and do not know it.

Regards.