Expression for summarizing categories

[#1]

Hi,

I have the following data in my model already (sample):

ID          AddedOn          FinishedBy

1          Sprint1               Sprint3

2          Sprint1               Sprint1

3          Sprint2               Sprint3

4          Sprint2               Sprint2

5          Sprint2               Sprint2

6          Sprint2               Sprint3

7          Sprint3               Sprint3

and I want to be able to put it in a table like below:

Sprint          No. of New/Additions          No. of Finished

Sprint1          2                                        1

Sprint2          4                                        2

Sprint3          1                                        4

How should I formulate the expression of my table/chart?

Thanks!

>Ronald

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for two solutions.

[#3]

Thanks Gysbert! I should have figured to try using If. I am leaning more on using the solution using If as the number of sprints can grow.

Thanks again!

[Kushal_Chawda]

Hi

I know you already got the solution, but still find the attched this one.

Regards,

Kush