Forum Discussion
Count items from a splitted string
Hello, I have some ideas for my report, but sadly, with my limited capability, I cannot visualize it. I want to count the skills most popular for each department and have a bar chart for that. Th...
I mean that all skills could be detected and counted for every department. For example, the result desired would be as follow: (headcount value would be larger than 1 if that department has 2 or more members knowing that skill)
Please tell me if it is still unclear
| Department | Skills | Headcount |
| A | AI | 1 |
| A | ML | 1 |
| A | Java | 1 |
| A | Angular | 1 |
| A | Cloud | 1 |
| B | Java | 1 |
| B | Angular | 1 |
| C | Mobile | 1 |
| D | React JS | 1 |