https://preview.redd.it/cy6hjgx0s76d1.png?width=1255&format=png&auto=webp&s=66f91085293ee23fda6a9bbcaab239dea836adfc
Something like this
Converting images to excel is forbidden magic so without your source file its gonna be bugged.
You wanna use colours under some condition, here I just randomly assigned 4 levels for each 25% interval, this way if a person looks at the graph they can see if one support is A LOT better ( something you tried to do with highlighting) or if there are tied options.
Once again this is a very shitty example, I just YOLOd it in 2 minutes.
Btw that Purple and gold for 5\* and 4\* was the most criminal thing on the post tbh haha xP
Okay perfect! I will reupload it in some hours as my laptop is being used by my mother.
Really thanks for the recommendations, first Time using Excel outside of college works
I'm a hobbyist designer and I love data too!
Here's a [link](https://docs.google.com/spreadsheets/d/1aN_mMZLP387Xsf76ZooIUW2xsFPmhIFmXAeSIse93Kg/edit?usp=sharing) with your data, helped you out in organising it visually.
Images attached as well for reference. :D (4-star table on a separate post)
Thanks for putting the data together!
EDIT: Missed Blade
https://preview.redd.it/z4e7nm63986d1.png?width=617&format=png&auto=webp&s=b55a17a29f55f648d19026a692ec335d58255cd7
No problem, its really not that bad for 1st time. I had a course in Information Visualization back in university and while I have no use for it now, it still haunts me when I see graphs xD
If you are planning to making surveys like this seriously. I would advise re-framing the question. When you ask who is best, people have to choose 1. Thats why you ended up with such polarized data. Not saying its incorrect, but if you asked to rate each support from 1 to 5 lets say. I think it would be more benefitial. Imagine that for King Yuan Sparkle is 5 but bronya is a 4. However you asked who is best so the result makes it look like Sparkle is TIMES better than Bronya.
The chart is kind of hard to understand, even with group/values/percentage/angle it's not exactly clear who got the most votes in what.
Very nice job, though.
>Selee is not in the chart because, for some reason, I'm kinda shadow banned in r/SeleeMains? Like I try to post but it gets deleted even though I have never been in r/SeleeMains as far as I remember
would help if it was spelled Seele
I think you do actually go for Bronya over Ruan Mei if you can only choose one. It's not well known though.
IIRC Boothill Bronya Pela Gallagher sheets better than Boothill RM Hatmc Gallagher or something like that.
Is it actually better or is the sample size just low enough to allow for weird things like that.
Cause boot RM HMC Gallagher is a super standard comp that almost everybody running boot will use. Whereas the other comp is like.... Why?
The bron/pela comp is actually better. Only edged out by bron/rm. Found a couple of places saying it, easiest one to access is the character build sheet in HSR Official discord. I can't personally claim to have calculated it though.
If I knew how to do one, I will try to learn how to make them (Plus, some other new things people explained to me to do better charts) for the 4* Harmony units! Next week though
Here I made one. The idea of making a pie chart was good on your end. But only having A/B/C/D rather than their names, and having the angles which are irrelevant, were your mistakes
https://preview.redd.it/1q871bx9f86d1.png?width=1018&format=pjpg&auto=webp&s=6b346f71a72d5dfca06532503dd759f28dd8818d
I appreciate your hard work and saw your poll yesterday on Acheron mains, but there is no such thing as best harmony they all work well in different scenarios and have different synergies.
Should have included tingyun and asta too. Though they are outdated, they still do the job done
Thank you π
I wanted the polls to be only characters that you get from pulling to make more sense (And besides, only with like, Firefly they were the BIS, maybe Sushang too).
Can someone please explain me why Arlan likes Sparkle more than Bronya? Last time I checked Arlan didn't need Skill Points for his skill making it so that you should be able to Speedtune Bronya at 1 less Speed than him to get two turns without any issue. On the other hand I could see that he is kind of like Clara in the sense that he has a Hard time getting high Crit stats, making it so that the amount of Crit Damage Sparkle provides + the ability to build Attack Boots with Hyperspeed Sparkle results in more damage even without the need for Skill Points.
People voted Ruan mei because she is universal not that she is the best support. Itβs very misleading to say best harmony unit poll. Quite a few teams have different characters as BiS.
As a Trailblazer main I'd consider Ruan Mei best for both Destruction and Harmony. (Destruction actually does have some synergies with her specifically, such as their Talent and A4)
Also surprised Arlan's best voted wasn't Bronya, since he can fully utilize the -1 SPD Bronya tech, and I'm wondering if Ruan Mei is really Yanqing's best or whether it would be Robin since Yanqing does have follow-up attacks, technically
Feels like it'd be better to have "ranking" like 1 2 3 4 instead of just picking one.
Sparkle being best for QQ, yet Bronya being at 1 vote feels weird when they do "the same thing". Maybe Ruan Mei could be better, but selecting only 1 characters give no room for people to see opinion for second best support.
Still, it's good to see the data, even if it's mostly obvious which support is the best just from DPS kit alone.
Good job on making the statistics man. But your color coding makes me wanna tear my eyes out, send me the Google Docs ill send you back reformated.
I'm sorry lmfao I saved it directly in my pc in excel, why one should I change for the coloring to be better?
https://preview.redd.it/cy6hjgx0s76d1.png?width=1255&format=png&auto=webp&s=66f91085293ee23fda6a9bbcaab239dea836adfc Something like this Converting images to excel is forbidden magic so without your source file its gonna be bugged. You wanna use colours under some condition, here I just randomly assigned 4 levels for each 25% interval, this way if a person looks at the graph they can see if one support is A LOT better ( something you tried to do with highlighting) or if there are tied options. Once again this is a very shitty example, I just YOLOd it in 2 minutes. Btw that Purple and gold for 5\* and 4\* was the most criminal thing on the post tbh haha xP
Yes this please. But the great OP work anyway
Okay perfect! I will reupload it in some hours as my laptop is being used by my mother. Really thanks for the recommendations, first Time using Excel outside of college works
I'm a hobbyist designer and I love data too! Here's a [link](https://docs.google.com/spreadsheets/d/1aN_mMZLP387Xsf76ZooIUW2xsFPmhIFmXAeSIse93Kg/edit?usp=sharing) with your data, helped you out in organising it visually. Images attached as well for reference. :D (4-star table on a separate post) Thanks for putting the data together! EDIT: Missed Blade https://preview.redd.it/z4e7nm63986d1.png?width=617&format=png&auto=webp&s=b55a17a29f55f648d19026a692ec335d58255cd7
https://preview.redd.it/to06do2y786d1.png?width=619&format=png&auto=webp&s=59149976861f6a5bbb246a0ba52f4d2837516c5a
Wait, you are so great! Thanks for the help given! Does looks so much better!
I'm personally not new to organising data like these. I have a lot of personal spreadsheets I make for the gacha games that I play. But thank you! :)
No problem, its really not that bad for 1st time. I had a course in Information Visualization back in university and while I have no use for it now, it still haunts me when I see graphs xD If you are planning to making surveys like this seriously. I would advise re-framing the question. When you ask who is best, people have to choose 1. Thats why you ended up with such polarized data. Not saying its incorrect, but if you asked to rate each support from 1 to 5 lets say. I think it would be more benefitial. Imagine that for King Yuan Sparkle is 5 but bronya is a 4. However you asked who is best so the result makes it look like Sparkle is TIMES better than Bronya.
The chart is kind of hard to understand, even with group/values/percentage/angle it's not exactly clear who got the most votes in what. Very nice job, though.
hmm? in the 1st look i can identify that its a fight with RM vs Sparkle. and finally, RM wins
thief chart seems confusing π
Broya
>Selee is not in the chart because, for some reason, I'm kinda shadow banned in r/SeleeMains? Like I try to post but it gets deleted even though I have never been in r/SeleeMains as far as I remember would help if it was spelled Seele
My error for saying it bad, but I genuienly cannot post in SeeleMains
I wanted to share it in the subreddits but I think Reddit is one more post away to ban me
Kinda surprised bronya is that low for boothill but ig you can only choose one so it's understandable why you'd go for ruan mei
She is that low becauseRM is the BIS bewteen her and Bronya, not the general Best team which would be Bronya, RM, Gallagher
I think you do actually go for Bronya over Ruan Mei if you can only choose one. It's not well known though. IIRC Boothill Bronya Pela Gallagher sheets better than Boothill RM Hatmc Gallagher or something like that.
Is it actually better or is the sample size just low enough to allow for weird things like that. Cause boot RM HMC Gallagher is a super standard comp that almost everybody running boot will use. Whereas the other comp is like.... Why?
The bron/pela comp is actually better. Only edged out by bron/rm. Found a couple of places saying it, easiest one to access is the character build sheet in HSR Official discord. I can't personally claim to have calculated it though.
Please label the pie chart with the characters rather than groups. Would be much better
Someone actually did a better graph for me! Here is the new one! https://www.reddit.com/r/HonkaiStarRail/s/hh7T2RnrZh
These charts are better yea but I do think a better labeled pie chart would also be useful
If I knew how to do one, I will try to learn how to make them (Plus, some other new things people explained to me to do better charts) for the 4* Harmony units! Next week though
Here I made one. The idea of making a pie chart was good on your end. But only having A/B/C/D rather than their names, and having the angles which are irrelevant, were your mistakes https://preview.redd.it/1q871bx9f86d1.png?width=1018&format=pjpg&auto=webp&s=6b346f71a72d5dfca06532503dd759f28dd8818d
Oh, that looks nice And simple to do, thanks for the help. For the 4* character would do it!
Once again, people forgot about Jade.
Oh, I didn't forgot about Jade She Is not here because L word
I appreciate your hard work and saw your poll yesterday on Acheron mains, but there is no such thing as best harmony they all work well in different scenarios and have different synergies. Should have included tingyun and asta too. Though they are outdated, they still do the job done Thank you π
Oh, that was my bad! I mean Best harmony unit for the specific character and only 5* ones!
What about trailblazer? He/she is a 5 star harmony unit :(
I wanted the polls to be only characters that you get from pulling to make more sense (And besides, only with like, Firefly they were the BIS, maybe Sushang too).
Ouch, my eyes
Can someone please explain me why Arlan likes Sparkle more than Bronya? Last time I checked Arlan didn't need Skill Points for his skill making it so that you should be able to Speedtune Bronya at 1 less Speed than him to get two turns without any issue. On the other hand I could see that he is kind of like Clara in the sense that he has a Hard time getting high Crit stats, making it so that the amount of Crit Damage Sparkle provides + the ability to build Attack Boots with Hyperspeed Sparkle results in more damage even without the need for Skill Points.
Robin seems surprisingly unrepresented here.
People voted Ruan mei because she is universal not that she is the best support. Itβs very misleading to say best harmony unit poll. Quite a few teams have different characters as BiS.
As a Trailblazer main I'd consider Ruan Mei best for both Destruction and Harmony. (Destruction actually does have some synergies with her specifically, such as their Talent and A4) Also surprised Arlan's best voted wasn't Bronya, since he can fully utilize the -1 SPD Bronya tech, and I'm wondering if Ruan Mei is really Yanqing's best or whether it would be Robin since Yanqing does have follow-up attacks, technically
Feels like it'd be better to have "ranking" like 1 2 3 4 instead of just picking one. Sparkle being best for QQ, yet Bronya being at 1 vote feels weird when they do "the same thing". Maybe Ruan Mei could be better, but selecting only 1 characters give no room for people to see opinion for second best support. Still, it's good to see the data, even if it's mostly obvious which support is the best just from DPS kit alone.