hi all,
I need to plot a chart to display user over lap of different services they have choosen. Below the sample data along with expected result.
How can we calculate user over lap on the given data ? can we do something at script level or can it be done in chart using aggr fn.
Source Data | Expected result |
User ID | Service | Services | User Count |
1 | S1 | S1 | 4 |
1 | S2 | S2 | 4 |
1 | S3 | S3 | 1 |
2 | S1 | S4 | 4 |
2 | S2 | S5 | 0 |
2 | S4 | S6 | 2 |
3 | S2 | S1-S2 | 3 |
4 | S4 | S1-S3 | 1 |
5 | S1 | S1-S4 | 1 |
5 | S4 | S1-S5 | 0 |
6 | S6 | S1-S6 |
7 | S1 | S1-S2-S3 | 1 |
7 | S4 | S1-S2-S4 | 1 |
7 | S6 | S1-S2-S5 | 0 |
7 | S2 |