Query For Chris Cleary

[merforga]

[–]from ChrisCleary sent 18 hours ago If anything I would probably ask for all parses above the 95%tile for each boss, skill damage breakdowns (don't think I'll need individual skill damages).

I can parse JSON data, but I would only need the finalized calculated outcomes not the individual events.

PermalinkDeleteReportBlock UserMark UnreadReply [–]to ChrisCleary sent 18 hours ago Easy..enough. So in terms of 95th percentile are you after squad dps, times, individual dps, class/profession dps? does archetype matter? We have a lot of 95th percentiles in this context XD

Permalink [–]from ChrisCleary sent 17 hours ago Individual performance of profession based on other performances from the same profession on the same boss (kills only). Archetype matters, composition does not.

PermalinkDeleteReportBlock UserMark UnreadReply [–]to ChrisCleary sent 17 hours ago Ez. Let me know if/when you'd want it and I'll get a query done up. Global stats is literally:

Individual performance of profession based on other performances from the same profession on the same boss (kills only).

Permalink [–]from ChrisCleary sent 17 hours ago I'll wait 2 weeks for the meta to mature and then likely ask for data from this patch and beyond. Too much flux right after a balance change :)

[merforga]

I will attempt to explain the result required using butchered SQL

FOR EACH ENCOUNTER in RAIDS SELECT Player.Professsion, Player.Elite,,Player.Archetype, Skills.damage, Skills.count, Player.TotalDPS, Player.CleaveDPS WHERE Player.Percentile => 0.95 AND IN Era.Current

[merforga]

Also just to clarify, I believe he wants the data down to per player (participant) level rather than aggregate . e.g instead of aggregate of all Soulbeasts in 95th in VG, it should show Soulbeast A, Soulbeast B etc etc

[merforga]

Bright :

all right, python3 bin/overachievers.py | bzip2 > ~/overachievers.jsonl.bz2 should give you ~/overachievers.jsonl.bz2. there's one already generated at ~amadan/.... Check it using bzless ~amadan/overachievers.jsonl.bz2. Hope that's okay. I'm about to go unconscious. o/

I haven't had a chance to look at the result of the above yet but just got some further clarification from the CC

How does this sound?

For all encounters 7/12 and beyond for players performing in the 95% since then

Performance based on profession broken down by boss including: Skill damage (MIN)(If Condi Break down Condi/Physical) Skill damage (MAX)(If Condi Break down Condi/Physical), Skill damage (AVG)(If Condi Break down Condi/Physical), Hits (AVG)(If Condi Break down Condi/Physical), Crit Rate (AVG per skill), Total Damage (AVG), Total Damage Taken (AVG), Total Condition Damage (AVG), Total Physical Damage (AVG)

So looks like he want just by profession now T__T per boss. (it's ok if it's at player level, we can just aggregate it manually after if too hard to bring it back up a level)

1. Skill damage (MIN)(If Condi Break down Condi/Physical)
2. Skill damage (MAX)(If Condi Break down Condi/Physical)
3. Skill damage (AVG)(If Condi Break down Condi/Physical)
4. Hits (AVG)(If Condi Break down Condi/Physical)
5. Crit Rate (AVG per skill)
6. Total Damage (AVG)
7. Total Damage Taken (AVG)
8. Total Condition Damage (AVG)
9. Total Physical Damage (AVG)

[amadanmath]

We don't have a lot of those info in the DB. What we have is what I extracted (per-skill DPS, per-skill total damage, per-skill crit rate, all power I think). No mins or maxes. AFAICR we can't know condi damage per skill since condis are not tied to skills like power damage is. So while we have power damage for Burning Retreat, we have condi damage for Bleeding (with no idea which skill caused Bleeding in the first place). (Also, oopsie but skill names is whatever the client reports them to be, so we have Searing Fissure but also Versengender Spalt...)

[merforga]

Hmmm I thought we had count of skill usage though no? If so we can manually calculate some of them.

[merforga]

Hmm some how ensolyss CM snuck into the data O_O

[merforga]

CC Query.zip

If anyone is interested in how I cut the data.

[merforga]

Update:

from ChrisCleary sent 1 day ago Last week was crazy but I'll have my team parse through this next week. Thanks a ton for getting this to me. Looks like I'm going to have to join skills together because of languages heh. I'm sure it's going to be a mess swapping over to skill ID, but that's one way to easily handle localization on the backend and allow frontent language configuration.

I'll get back to you sometime next week. TY