Forum Discussion

RoxanaZaharia's avatar
RoxanaZaharia
Icon for Helper I rankHelper I
2 years ago
Solved

duplicates?

Hello! I am working with this data set for my first project: https://www.kaggle.com/datasets/krishd123/olympics-legacy-1896-2020 , and i am trying to show top participants by the number of times they...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    RoxanaZaharia ,

     

    make another visual like a bar chart that displays each name with the number of participation.

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

The result makes sense because you have multiple values for Event (for one unique person). To get what you want, you have to create an additional measure using CONCATENATEX which will bring all the Event values into one row.