Hi, I'd really appreciate some advice on this.
I have a data set looking at users and the apps they have access to. There are 3 apps in total.
I want to be able to product a pie chart or visualisation showing the combinations that users have access to.
Can anyone give any suggestions on the type of query I need to write?
Sample data attached
| UserID | App1 | App2 | App3 |
| 1 | 0 | 1 | 0 |
| 2 | 0 | 1 | 0 |
| 3 | 0 | 1 | 0 |
| 4 | 0 | 1 | 0 |
| 5 | 0 | 0 | 0 |
| 6 | 0 | 0 | 0 |
| 7 | 0 | 0 | 0 |
| 8 | 0 | 0 | 0 |
| 9 | 1 | 1 | 1 |
| 10 | 1 | 1 | 1 |
| 11 | 1 | 1 | 1 |
| 12 | 1 | 1 | 0 |
| 13 | 1 | 1 | 0 |
| 14 | 1 | 1 | 0 |
| 15 | 0 | 0 | 0 |
| 16 | 0 | 0 | 0 |
Many thanks,
Tim
