Forum Discussion
BassG
Helper I
Helper IAnalyse & slice data by delimiter, but not split rows.
Hi all, I've got an issue that I can't seem to work out & looking for help on what the best solution would be. My data looks a little like this... Studen t ID SIMD Sport 1 Sport 2...
BassGHelper I
Helper II think you're on the right track with having a table of the sports, but you maybe misunderstood what I'm trying to do?
I want to have graphs like the 2 above - showing the % in each SIMD band (1-5) but with a single dropdown slicer for the sport.
If I use split by row and no individual sport is selected, it counts "Has Sport" multiple times for each student with more than 1 sport.
I wonder if I use a concat with the Student ID for "Has Sport", if that would work with the Split Rows by Delimiter?
SamWiseOwl
Super User
Super UserHi BassG
I am not fully understanding the goal.
Using SIMD 3 what is your assumption?
Mine would be:
All Sports selected: 2 / 3 = 66%
Judo: 1/3 = 33%
Football: 2/3 = 66%
| 4123 | 3 | Shinty | Rounders | Football | Judo | Shinty,Rounders,Football,Judo | 1 | 1 | |
| 4321 | 3 | Football | Football | 1 |
1 |
||||
| 1323 | 3 | 0 |
1 |
- SamWiseOwl