Table: Two columns as single dimension

[#1]

Hi there,

My data is log-type data looks like this

number	Opened time	opened_by	resolved_by
1	01/05/2016  00:00:00	H	W
2	01/05/2016  00:05:00	Y	G
3	01/05/2016  00:10:00	F	W
...	...	...	...

Where opened_by and resolved_by detail individuals who opened and resolved an incident.

I want to create a table (either flat or pivot) that looks like this:

Individual	No of incidents opened	No of incidents resolved
A	12	5
B	8	14
C	21	15
...	...	...

Can anyone provide any direction? I attach the data.

Thanks,

Conor

[#2]

folow

[Gysbert_Wassenaar · Accepted solution]

See attached app.

[#4]

I can't seem to open this in Qlik Sense. When I put it in my apps and open it in Desktop no sheets appear.

[#5]

This was perfect! Thank you.