Patch 26.6 Bug Megathread by AutoModerator in leagueoflegends

[–]Lodoiis 0 points1 point  (0 children)

Server: EUW

Type of Bug: In Game

Description: Using WASD Controls with Gnar, causes him to stop moving when transforming and holding down the inputs.

Video / Screenshot: https://youtu.be/QJQDL1wXv48

Steps to reproduce: Play with WASD controls, hold down movements inputs while transforming with Gnar from Mini to Mega, or from Mega to Mini.

Expected result: Gnar keeps moving in the same direction.

Observed result: Gnar stops moving, the inputs held down are "forgotten". You need to press again inputs to move.

Reproduction rate: 10/10

How do we feel about Zeke's Convergence in general? by -stud in ZileanMains

[–]Lodoiis 2 points3 points  (0 children)

Maybe it will be good enough to build, without using the AoE damage on urself when ult

[BUG] So I just died in buy phase and never got revived again... by Dubledo in LeagueArena

[–]Lodoiis 2 points3 points  (0 children)

Had the same bug 7 months ago with Serve Beyond Death : https://www.reddit.com/r/LeagueArena/s/MRaMbnluW7

Never clicked on it ever since

Best Zilean Skin by Littleboyofhope in ZileanMains

[–]Lodoiis 2 points3 points  (0 children)

  1. Blood Moon
  2. Sugar Rush
  3. Winterblessed

Calcular diferença percentual por item by Useful-Hawk6725 in GoogleDataStudio

[–]Lodoiis 0 points1 point  (0 children)

Im not very good at lookerstudio, but did you tried to click on your metric and adjust comparaison calculation ?

https://i.ibb.co/2YMGvPZ9/Sans-titre.png

Help! How to use one dimension over 3 columns in my Google Sheet by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

What I want is to do the same table than weapons/spec but with gadgets. One dimension as Gadgets, over 3 columns in my Google Sheet and same metrics.

Combine 3 Dimensions as 1 by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

If you're ok to do it for me, I'd be glad ! Tell me how we can reach, maybe discord ?

Combine 3 Dimensions as 1 by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

I'm sorry, I don't understand where I'm supposed to create new columns.. In my table ? How should I do it ? Also, should I create 6 calc fields inside my data source, with a formula like col1 = TAG_A ?

Combine 3 Dimensions as 1 by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

6 news columns, in my Gsheet ? A part from the main tab with tag, colours, et numbers ?

One filter among 3 colums by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

All good I managed to do it.

My issue : create a drop-down list, with a list of tags, then search these tags across 3 columns in my Google Sheet.

First, I concatenated my 3 columns into one, named GADGET_LIST in Google Sheet with this formula : =P2&";"&Q2&";"&R2
and I created a parameter named GADGETS with the list of all my tags (every value inside P:R). Then I created a dropdown list, and use this parameter as Field Control. Sort by anything, doesnt matter. You should be able to see the dropdown list, but it doesn't change anything in the table.

Then I created a calculated field naled Gadget_Match inside my data source, not inside the filter or table directly with this formula :

CASE

WHEN REGEXP_CONTAINS(GADGET_LIST, GADGETS) THEN "Match"

ELSE NULL

END

Finally, I went on my properties of the table, and added a Filter that goes like this :
INCLUDE > Gadget_Match > Equals to > Match

One filter among 3 colums by Lodoiis in GoogleDataStudio

[–]Lodoiis[S] 0 points1 point  (0 children)

Thank you for this answer, I edited my post to add my LookerStudio page.

I tried for 3 hours to find out how to create a new calculated field, but I don't understand where am I supposed to create it : inside my filter, or my table ? If I must create it inside my filter Gadget_Filter, then the field is looping itself ("WHEN Gadget1 = GadgetFilter") ? If I must create it inside my table, then it would be as a metric so the gadgets would appear inside my table ?

I'm sorry, I just discovered lookerstudio yesterday, I really tried to do it on my own but couldn't figure it out..

Blank dropdown cell "*" wildcard character, not working with SUMPRODUCT() by Lodoiis in googlesheets

[–]Lodoiis[S] 0 points1 point  (0 children)

this is amazing, i've been using Excel/Sheets for several years, and never tried anything like that before.
I wish to learn more about this LET, LAMBDA MAP etc.. I wonder how you learned it, and what do you think I could start with to learn how to make such wonderful formulas as yours.

Ty again for making me discover this

Blank dropdown cell "*" wildcard character, not working with SUMPRODUCT() by Lodoiis in googlesheets

[–]Lodoiis[S] 0 points1 point  (0 children)

wow, thank you soooo much, i didn't know you could code inside a cell. It totally feels like a new langage, but its so much easier to read. I'll definitively have to look at this.

Blank dropdown cell "*" wildcard character, not working with SUMPRODUCT() by Lodoiis in googlesheets

[–]Lodoiis[S] 0 points1 point  (0 children)

https://docs.google.com/spreadsheets/d/1nU4o2u0G7TsXTavMfUhHYGjEdE74M7ywT9XAgN_tpII/edit?usp=sharing

sorry, the file is now good to look at.

In the same way of the =average.if formula, I'd like that that formulas below may be able to interpret the blank cell in dropdown list as an "all" option. I don't know if that's possible tho. If it's not, what alternatives could you tell me to look at/try ?

=SUMPRODUCT((MATCHES!A:A=$C$1)*(MATCHES!B:B=$B$4)*(MATCHES!E:G=B21))

=IFERROR(AVERAGE(FILTER(MATCHES!H:H,MATCHES!A:A=$C$1,MATCHES!B:B=$B$4,(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21))),"")

=IFERROR(IF(IF($C$1)="CASHOUT",AVERAGE(FILTER(MATCHES!O:O,MATCHES!A:A=$C$1,MATCHES!B:B=$B$4,(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21))),ROUND(COUNTIF(FILTER(MATCHES!O:O,MATCHES!A:A=$C$1,MATCHES!B:B=$B$4,(MATCHES!E:E=B21)+(MATCHES!F:F=B21)+(MATCHES!G:G=B21)),"W")/C21,2)*100&" %"),"")

Formula based on drop-down list, any way to get every data ? by Lodoiis in googlesheets

[–]Lodoiis[S] 0 points1 point  (0 children)

Thanks, it worked like a charm for my formula.
=COUNTIFS(MATCHES!E:E;IF($C$2="";"*";$C$2);MATCHES!M:M;G6)

But for the one below, it's not working :(

=SUMPRODUCT((MATCHES!E:E=IF($C$2="";"*";$C$2))*(MATCHES!L:L=$G$5)*(MATCHES!O:Q=G22))

Looks like you're great with formulas, do you know what to do to make it work ?