Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
folow
See attached app.
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.
This was perfect! Thank you.