Forum Discussion

BassG's avatar
BassG
Helper I
1 year ago
Solved

Analyse & 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...
Need Help
SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi BassG 

Instead of splitting Concat Sport into columns consider splitting it into rows.

I've attached a file that splits it into rows and seperates sports into another table.

  • BassG's avatar
    BassG
    Helper I
    1 year ago

    I 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's avatar
      SamWiseOwl
      Super User
      1 year ago

      Hi 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