Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have only recently started to use Set Analysis for simple selections. I am looking for a steer as to how to tackle a particular challenge.
Given the below data set, how do I could the number of Projects (using Project ID) that have 0 - 5 open risks, 5 - 10 open risks etc.
Many thanks,
A
Data Set
Projects ID | Risk ID | Status |
P001 | 16 | Open |
P001 | 15 | Open |
P001 | 14 | Open |
P001 | 13 | Open |
P001 | 12 | Open |
P001 | 11 | Closed |
P007 | 10 | Cancelled |
P008 | 9 | On Hold |
P008 | 8 | Open |
P008 | 7 | In Progress |
P008 | 6 | Cancelled |
P008 | 156 | Closed |
P008 | 4 | Open |
P014 | 30 | Proposed |
P015 | 2 | Cancelled |
P016 | 1 | In Progress |
P017 | 100 | Open |
P018 | 1 | On Hold |
Desired Output
0 - 5 Open or On Hold Risks | 5 - 10 Open or On Hold Risks | 10 - 5 Open or On Hold Risks | etc |
---|---|---|---|
# of projects by Project ID | |||
See attached qvw
see the attached one
Thanks G Wassenaar & Kush141087 for your help with this. Much appreciated.
I have used the solution provided by G Wassenaar. Whilst it was slightly different to my original request it is the most elegant solution to my current challenge, however I will need to use both solutions further down the line.
Thanks again to both of you.
A