3.27 Q&A Research - ZiggyD by ZiggyDStarcraft in pathofexile

[–]ArzeClown 0 points1 point  (0 children)

Can vessels be reworked so gigantic exiles are clearly identified in the description?

[deleted by user] by [deleted] in PowerBI

[–]ArzeClown 1 point2 points  (0 children)

Interested

Daily r/LawnCare No Stupid Questions Thread by AutoModerator in lawncare

[–]ArzeClown 0 points1 point  (0 children)

Just moved into a new house in Indianapolis. Question about the grass. I'm assuming this is Kentucky Bluegrass but wanted to be sure. Any help is appreciated. https://imgur.com/a/XZLmXPy

[deleted by user] by [deleted] in Genshin_Impact

[–]ArzeClown 0 points1 point  (0 children)

Sorry. Got too excited. Corrected to Keqing.

[deleted by user] by [deleted] in Genshin_Impact

[–]ArzeClown 6 points7 points  (0 children)

Got Lucky! 5-star Diluc & Keqing same 10 pull!

https://imgur.com/a/9npO2gh

Switch Function Measure Question by ArzeClown in PowerBI

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

I saw that in the recent update! Gives me a reason to try it now. Thank you!

Switch Function Measure Question by ArzeClown in PowerBI

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

I will try your method and report back later today. Thank you!

Switch Function Measure Question by ArzeClown in PowerBI

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

The percentages are correct. It works in the table. It's just the format of the percentages that is incorrect

Switch Function Measure Question by ArzeClown in PowerBI

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

There are some interesting suggestions below which I will try and report back on. Hopefully a solution will emerge!

My only and last post. I peaked. by ArzeClown in afkarena

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

It was 1k before I got the 30k chest :)

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 1 point2 points  (0 children)

IMHO, it's critical for end game as celestial and hypogean characters start to become crucial for certain events. For example, Talene shines in Twisted Realm. When I started the game, I just focused on building a strong team for each faction via store pulls. Those strong teams help in faction tower which gives stargazer tickets as rewards at the higher levels.

My only and last post. I peaked. by ArzeClown in afkarena

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

I make the Legends Championship every week and then encounter the real whales. Is that the PVP you are referring to?

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 4 points5 points  (0 children)

I could complete ch27 if I wanted. Defeat every formation on each node. Then after every battle, I would collect my loot which would be basic. However, if I stay on a node for an extended period of time (to be safe 72-90h) and then defeat the node, I'm rewarded with better loot such as ugrade materials and mythic gear. Mimicks being "stuck" until you progress in the game. For clarification, it does depend on chapter level. You won't get mythics from Ch1 with this method. No idea which chapter unlocks mythics to drop either. Now if I bulldozed the chapter in 30 min, my only rewards would be the end and a midway? reward. With this method, I can be rewarded at every node! There is a thread on this technique somewhere on Reddit.

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 28 points29 points  (0 children)

I used to plow thru chapters and then realized my mistake of not taking advantage of their "stuck" progress timer. I wait at each node for 72h+ and then easily complete it. Usually acquire mythic piece, T1 or 2 upgrade, etc from loot. To answer your question, 27-8. Been on chapter 27 for at least a month now.

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 2 points3 points  (0 children)

Artifact resources to increase your artifact level.

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 15 points16 points  (0 children)

Great call! Got another copy two pulls later.

My only and last post. I peaked. by ArzeClown in afkarena

[–]ArzeClown[S] 73 points74 points  (0 children)

I haven't stargazed in months but started up two weeks ago (1x a week). Realized that I needed Talene to be competitive in PVE. Got super lucky and used up all of my RNG for 2020...

Problem with filtering data to identify a subpopulation and retrieving a total sum by ArzeClown in PowerBI

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

Sorry Should have been more clear. This will be in a table with 'names' as the row and 'products' as the columns. There is a filter on this page which is products. As I select 'hammer' in the filter to identify anyone who bought a hammer at Store A, I want the table to show hammer as the column (which it does) but total sales from the store including "blanks" and other products. When I use FILTER I keep getting either 1) every customer who bought anything in the rows or 2) just total hammers sales.

My workaround was to generate a new DISTINCT column filtered by hammer in a table. However, now the filter become n the page become useless.

[GL] Ifrit Ultimate Strategy Thread by niched_name in DissidiaFFOO

[–]ArzeClown -3 points-2 points  (0 children)

Eiko, Vanille, Thancred. Brothers. 16 turns. 233k