search

rawgraphs / rawgraphs-charts

A curated selection of charts provided through RAWGraphs interface
https://rawgraphs.io/
Apache License 2.0
92 stars 43 forks source link

Duplication of some names in step 1 #136

Closed melissamackay closed 1 year ago

melissamackay commented 1 year ago

In which chart does the bug happen?

RAWGraphs Version

2.0

Web browser and version Chrome Version 107.0.5304.89 (Official Build) (64-bit)

Operating System

Windows 10

Steps to reproduce this

Using a simple dataset with overall 19 universties describing the categories of courses they offer (3 different categories). I pull the university as the first step, then the next column is the number associated with the category of courses (1-3). For 15 of the universities, the name is only listed once in step 1 and the lines go to the numbers 1-3. But for 3 universities, no matter how i put the data in, the names are repeated and new lines go to the next step 1-3.

Project file

Additional context

For data vis.xlsx

mikima commented 1 year ago

Not clear to me the issue. This is the result that i get, it seems correct to me. Can you annotate on the image what is wrong? thanks! (I also upload the project file to reproduce it: viz.rawgraphs.zip). viz

melissamackay commented 1 year ago

Hi there,

The issue is that a number of universities are repeated on the right. So University of British Columbia (#2), Brock University (#3), and Universite de Montreal (#4) are all repeated in the list rather than only having one instance as they should.

Melissa MacKay, PhD (she/her) Postdoctoral Scholar, Population Medicine University of Guelph @.***

From: Michele @.> Sent: June 5, 2023 6:34 AM To: @.> Cc: Melissa @.>; @.> Subject: Re: [rawgraphs/rawgraphs-charts] Duplication of some names in step 1 (Issue #136)

CAUTION: This email originated from outside of the University of Guelph. Do not click links or open attachments unless you recognize the sender and know the content is safe. If in doubt, forward suspicious emails to @.***

Not clear to me the issue. This is the result that i get, it seems correct to me. Can you annotate on the image what is wrong? thanks! (I also upload the project file to reproduce it: viz.rawgraphs.ziphttps://github.com/rawgraphs/rawgraphs-charts/files/11651546/viz.rawgraphs.zip). [viz]https://user-images.githubusercontent.com/907536/243327191-bce7533f-88ac-437c-add8-5b6ef254ecba.png

— Reply to this email directly, view it on GitHubhttps://github.com/rawgraphs/rawgraphs-charts/issues/136#issuecomment-1576540334, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A4DDG23AL7G6QOZIGXZKEUTXJWYRFANCNFSM6AAAAAAX3EGMZA. You are receiving this because you authored the thread.Message ID: @.***>

mikima commented 1 year ago

The issue is related to the dataset: some values has double spaces, or spaces at the end of the string (see the screenshot, i highlighted some of them). RAWGraphs intepret them as different values. I suggest you to check the dataset with a tool like Open Refine to trim whitespaces and check inconsistencies (e.g. capitalization, typos)

Screenshot 2023-07-06 at 23 10 51
melissamackay commented 1 year ago

Thanks Michele, the website is helpful as those differences are not visible in the Excel dataset.

Thanks, Melissa

Melissa MacKay, PhD (she/her) Postdoctoral Scholar, Population Medicine University of Guelph @.***

From: Michele @.> Sent: July 6, 2023 5:13 PM To: @.> Cc: Melissa @.>; @.> Subject: Re: [rawgraphs/rawgraphs-charts] Duplication of some names in step 1 (Issue #136)

CAUTION: This email originated from outside of the University of Guelph. Do not click links or open attachments unless you recognize the sender and know the content is safe. If in doubt, forward suspicious emails to @.***

The issue is related to the dataset: some values has double spaces, or spaces at the end of the string (see the screenshot, i highlighted some of them). RAWGraphs intepret them as different values. I suggest you to check the dataset with a tool like Open Refinehttps://openrefine.org/ to trim whitespaces and check inconsistencies (e.g. capitalization, typos) [Screenshot 2023-07-06 at 23 10 51]https://user-images.githubusercontent.com/907536/251575833-bf978b54-2431-430f-a19a-d568ba77ae00.png

— Reply to this email directly, view it on GitHubhttps://github.com/rawgraphs/rawgraphs-charts/issues/136#issuecomment-1624317321, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A4DDG26O6N7BCRWHKZGH2UDXO4TANANCNFSM6AAAAAAX3EGMZA. You are receiving this because you authored the thread.Message ID: @.***>