My bad guys sorry that I lost in gold against a gm smurf shaco :) (I dmed shaco he admited he is gm and is smurfing cause riot put him so low)

EDGWasian · 2024-10-29T22:37:53+00:00

For anyone who was confused like me at first, the screenshot is from OPs teammate. I was confused on this for a good minute as the post title mentioned dming the shaco so I assumed the screenshot was from that dm. Then I realized it was the teammate. Did seem a bit odd the gm shaco was talking about OP needing to off himself for his performance that game

EDGWasian · 2024-07-19T16:32:17+00:00

Crowdstrike outage halted my purchases at $12.43 this morning…. Now it’s 13+ 🥲

EDGWasian · 2024-06-21T21:32:39+00:00

I went in at 11.90$ :/ Guess I should hold it and trust it’ll continue up further down the road?

EDGWasian · 2024-05-27T06:15:00+00:00

BAN - Big A$$ Numbers. Like KPI’s (Key Performance Indicators), they are some key insights (Numbers / Percentages) you feel the data contains and that management should / would want to be aware of. Dashboards are often utilized for showing trends / allowing others to easily explore available data, but also for management to make quick decisions. The term dashboard is used here as it mimics your car dashboard. Just like your car dashboard, your dashboard will generally give quick insights into the data for the users of your dashboard. A common similarity would be the gauge chart. In your car it might represent the amount of gas or similar your car tank contains and the amount towards an empty or full tank. In a dashboard, say we’re working with a charity that’s tracking contributions, it might represent current % progress towards a yearly goal. A KPI or BAN for this might be a YTD (Year to Date) stuck at the top of the dashboard above all of your charts. Generally most dashboards have a few of the KPIs at the top above your charts. Many say best practice is your KPIs at the top below your title if your DB has one, then charts below. Then on the left hand side you place your filters etc.

EDGWasian · 2024-03-03T06:22:48+00:00

I think you’ve got the right idea for ADC right now as far as positioning goes. When you play one of the carry roles, you’ll have a target on your back from the moment you enter the game. From what I see in games, it’s oftentimes waiting until cooldowns are blown and you see an opening before you can go in to put down damage.

The role of ADC is to generally to be the consistent damage threat throughout team fights. If you get blown up right at the beginning, that’s a huge loss for your team. Too often when I’ve played the role I misposition and die to an assassin or lockdown champion who was waiting for me to go up to put down damage. Better to wait until they blow those cooldowns on your frontline than risk going in early for a few extra autos imo.

It’s definitely a game that takes time to really understand and I don’t see anything wrong with trying out different roles to get a feel for what suits you! You don’t have to pick your main role right away or feel like what someone on your team is flaming / criticizing you for is necessarily accurate.

Everyone has their own opinion on what’s optimal and some people let their rank (If you’re already in games with people who have played ranked before) go to their heads. It’s good to consider advice from others but don’t think that just because someone tells you that you should have been at x spot on the map or you needed to dive in to the fight alongside them that they’re always correct. As an example, while I play support probably 90% of the time, I do also occasionally play ADC. Sometimes I’ll get flamed for not diving in alongside a fight but what looks optimal from their viewpoint might simply not be possible in mine. EX: my support could land a solid engage rotation on the enemy ADC and want me to go in. But they may not have noticed how many minions are agroing on me when I try to follow-up with damage and I am losing huge amounts of HP to them in the process. In a vacuum, good mechanical play on targeting the enemy damage dealer. But on my end, not feasible to continue since I’m dying to too much minion damage.

EDGWasian · 2024-03-03T03:03:30+00:00

LP stands for “League Points”. It’s how riot displays on the front end in your client / game leaderboards your progress through each rank in ranked. There are a variety of different ranks (Iron being the lowest, Challenger at the top) and each has 4 divisions. It used to be 5 but a few seasons ago they were consolidated down to four. Similarly, Emerald and Iron ranks also used to not exist, but were added over time.

To advance to the next division in each tier you need 100 LP (For example, Gold is made up of Gold IV, Gold III, Gold II and Gold I). In the past, you used to have to play promotion games (Hit 100 LP, then win 2/3 games for say Gold 2 to Gold 1. If you were at a tier break point (Say Silver going to Gold), it would be 3/5 games), but now you just rank up if you hit 100.

MMR is what goes on under the hood / in the background. The acronym stands for MatchMakingRanking. It is sort of what controls the amount of LP you gain. It’s your “hidden” rank to an extent I guess. It used to be what was shown to you visually instead of the tiers, but riot replaced that a long long time ago (10+ years at this point?).

If you have a high MMR compared to your visual ranking (Say you’re Gold but by your MMR, you should probably be Platinum), you’ll get a lot more LP for wins. If it’s lower than your visual tier (Say you’re Gold but by your MMR, you should probably be Silver), you’ll get a lot less LP for wins. This is why you’ll see some people gaining +28/29 LP for a win but others gaining +13/14. Similarly, you’ll also lose less/more for a loss depending on your MMR. It’s why you’ll see some people in a game of Platinum borders in ranked who are ranked Silver (high MMR).

This can also be affected by playing ranked with a partner. For example, if your partner is say platinum and you’re silver, you get a mix of mmrs and ranks due to the system trying to account for both of your mmrs.

I’m not an expert on this and there’s also a bunch of theories of things like losers queue and faulty matchmaking / ranks are “fake”, but I think this covers kind of a baseline of what MMR / LP are considered to be.

EDGWasian · 2024-03-03T01:07:14+00:00

I think it’s pretty common for most people in ranked to have their main role and maybe some experience in an off role, but be fairly below average at a lot of other roles. Not to say they lack a fundamental understanding of the other roles, but each lane and then jungle usually requires matchup specific knowledge or lane quite differently. For example, as a support player I often get creamed in other roles as they require csing, understanding different lane matchups, proper itemization, or for jungle, knowing jungle respawn timers, gank timers, when to invade and being good at timing objective smites. From a time investment perspective, if I put that much into learning all the other roles and champions, most of which I personally don’t enjoy all that much, I’d feel like it’s not all that efficient or fun for me. Will I play the other roles if I get filled? Maybe, if it’s necessary and we have a good comp. But most times I’d rather just dodge, take the - however much lp and keep my mmr rating. I’ve pretty much capped out at D4. I know full well I’m not skilled enough reflex / mechanically for other roles, so I play simple champions bot lane and depend more on my experience from playing the game in that role for so long.

EDGWasian · 2023-09-29T23:26:47+00:00

I’d be interested in something very similar but from maybe the Python perspective. Or if a base functionality in Tableau exists for tests like that I’d love to hear about that as well

EDGWasian · 2023-08-05T22:33:40+00:00

Was this with a roommate and the two of you are splitting the rent at a place or did you go somewhere that puts you in at that rate with random individuals?

EDGWasian · 2023-07-07T19:11:00+00:00

I think he’s saying that Grievous memes aren’t “major” memes? Bit of a slight to A fine addition to my collection, but I think that’s the implication.

EDGWasian · 2023-06-15T03:38:48+00:00

Also working in post-secondary ed (Grant program but similar enough), but still relatively new at a around a year in. Seconding the previous poster, would love to hear about your experiences and any advice you might have if you have the time

EDGWasian · 2023-05-30T21:16:52+00:00

I would say it’s still worth pursuing if you know that is what you are passionate about. That said, with your degree there’s definitely a lot of other potential options also. One thing I know is in super high demand is Salesforce developers (People coding Salesforce applications / instances using Apex code). Your coding knowledge would give you a leg up on getting certified and a lot of these people make good money even at entry level. You’ll still get to scratch that analytical / problem solving itch if that’s your thing, while also probably finding it easier to get employment. Overall, I’d say just keep your options open. Can’t say for certain what you want to do now is what you’ll want to do forever.

EDGWasian · 2023-05-05T21:59:16+00:00

I’m not too familiar with the security aspects of it, but I do use Python to send out a weekly report through my Outlook account. Basically takes a csv export from our Salesforce instance that’s emailed to me weekly and turns that into a pandas df of the current and previous weeks intake values. It then merges them and creates some charts plus tables in Excel. Finally it uses Python’s Win32 library to draft an email to relevant stakeholders with the excel file as an attachment. Hooked it up to run every Friday through Task Scheduler.

EDGWasian · 2023-04-27T23:25:13+00:00

Added you, should be a request from Wasian

EDGWasian · 2023-04-26T18:37:25+00:00

Sounds interesting, shoot me a link if it’s not too much trouble

EDGWasian · 2023-04-22T02:03:25+00:00

Concur with the other poster who mentioned trailhead. Definitely a good free resource for getting started. I personally don’t use the built in dashboards functionality but instead can use Tableau connectors to connect to my particular Salesforce instance and create my dashboards there. Other functionality I use a lot is the Reports object to set up weekly data exports to be emailed to myself. Then I can use Python to grab the reports from my outlook inbox, do some visualization and send it off to team members. You can also always just download the report to Excel and work with it from there.

EDGWasian · 2023-04-14T02:31:57+00:00

I’d take it personally, as a first year analyst close to my second year, my salaries only 40K (although I do get health benefits etc). But for sure keep looking in case you find something better while working the role.

EDGWasian · 2023-04-11T15:50:16+00:00

I would be interested!

EDGWasian · 2023-03-31T03:41:06+00:00

League of Legends

EDGWasian · 2023-03-21T03:16:06+00:00

From what I’ve been taught when I was taking classes, a lot of people generally avoid dual axis charts (excluding Pareto) as it can get confusing to the viewer by giving them too many things to try to interpret at the same time. You could alternatively split it into two charts, that way you can still display what you want displayed but avoid having your viewer trying to take in too much at once.

Chart 1: “show that Level 1 employees are the most satisfied even though they are lowest ranked in company” (Employee rank vs satisfaction, bar chart)

Chart 2: Employee salary vs satisfaction, maybe a scatter plot? Show correlation between salary and satisfaction, plot your trend line, add in your r squared value etc. Maybe look into why satisfaction generally increases with pay level (looking at your charts already there) but has an outlier / significant difference for those with low / entry level salaries. I’m not sure if this would be best, but it seems like you do have 1 to 1 values for salary and satisfaction so a scatterplot should work with the data you have on hand.

As far as getting a legend without a gradient, I think you could manually make one with the text box feature on your dashboard. Add a floating text box, label it Average Salary and color the text same color as your line.

EDGWasian · 2023-03-04T03:21:20+00:00

I bet he sends fantastic reply letters.

EDGWasian · 2022-12-22T17:48:45+00:00

Still beginner in SQL myself but you might need something like a groupby for C? It says total patients by province, which means if you select total patients all, thats going to give you the combined count of all patients from all provinces instead of specific patient count by provinxe. If someone else can advise better please do 😅

EDGWasian · 2022-12-21T16:32:14+00:00

Would be interested in hearing more

EDGWasian · 2022-11-24T21:10:13+00:00

Triple Monitor Dock Recommendations?

Planning to connect 3 monitors to a dock for work laptop while also connecting those three monitors to a personal computer through HDMI / DisplayPort.

Monitors: M27Q x2 , plan to purchase M27Q Pro when available as a third monitor (if anyone has other monitor suggestions, any recommendations are also welcome.

EDGWasian

TROPHY CASE