A sub-reddit for moments in the legend of zelda series where 'Link' dies inside (E.G doing a Korok puzzle and dropping the a piece of the puzzle of a mountain.)
Anarchism, Bitcoin, Seasteading is a place to talk about the overlapping needs of Anarchist Seasteaders & Bitcoiners. - Is Bitcoin Mining the missing piece of the Seasteading puzzle?
This subreddit is for users to exchange jigsaw puzzles with each other. Just post a picture of the puzzle you have to offer and wait for someone to trade it with you.
La-Mulana is an iconic cult classic of a puzzle metroidvania. Exploring old ruins and solving puzzles as a whip wielding archeologist is a wonderful hook for a MV, and La-Mulana delivers on this vision in a grand scale.
La-Mulana is also infuriatingly impenetrable. La mulana is a hard game, but hard in a way that does not advantage skilled MV players that can take no damage and pull off move tech to get places. La-Mulana breaks the player's spirit with puzzles. Puzzles range from fair to unfair1 with many puzzle pieces being deliberately disorganized. Players hit wall after wall after wall. Players either move on and don't return or players look up answers to puzzles and the fun goes away.
I contend that playing La-Mulana co-op style will significantly alleviate the pain points that cause people to bounce off the game. Thus team.
I contend that most players need some context and guidance to maintain forward momentum without the feeling of being given the answers. Thus curated. Also, i like watching blind la-mulana playthroughs.
This summer, I'm interested in organizing la-mulana teams to play through La-Mulana 1[The remake]2. I'm looking for interested players. I'm incredibly interested if players want to sign up as a partnership or team.
I'm looking at a schedule like June 8th through August 3rd, 8 weeks, weekly check ins.
Drop a comment if you are interested or have questions. Thank you!
(1)Please don't quibble about this in the comments, discussion will get meta/spoilery.
(2)I'm also looking to run a La-Mulana randomizer boot camp. The randomizer is fabulous.
Hello people, I have recently purchased my first synthesizer, the Korg Volca Bass. I would like to record the sounds, a friend gave me the M-Audio M-Track solo. All of these things are currently connected to each other, but GarageBand is not playing back what Iâve played into it. What am I doing wrong? I have read things about mono and stereo and the volca bass might be a mono thing, the m-track is stereo. I also have seen that a mixer might be necessary, which could be my only missing puzzle piece. My synth store is closed today otherwise Iâd be bothering them about this.
I did learn that the Focusrite audio interface is supposed to be the best beginner thing, but if I can make it work with the m track thatâd be sick. I dunno yâall, I just like documenting my sounds. Iâm not trying to make an album. Any advice and help would be super rad, many many thanks in advance <3
if buddy donât pop back out soon that means them UMG black vans done found himâŠwe sadly might have to find different pieces to finish this puzzle đ§©
Anyone else think Aspyn REALLY wants to share Eâs name but thereâs something obviously holding her back? I saw a comment yesterday on the main sub about how Eâs name was leaked by the same person who leaked the cancer diagnosis about C, and Aspyn canât confirm one without confirming the other, in redditâs eyes at least.
Aspyn knows this, which is why sheâs only very vaguely confirming the new babyâs name by saying âoh yeah, a lot of people have guessed her name correctly but I wonât confirm or deny which guess is rightâ and the barely-covered name in the puzzle. If she downright says her name is Elle, then that puts the last âpiece of the puzzle togetherâ for us snarkers who know/believe the leaker was correct, especially since theyâve gotten everything else correct thus far (ie the divorce, Eâs birthdate/early birth, and now baby #3âs name).
I have maxed out one of my managers and I will randomly get puzzle peices for him. What do they do? They will say spare puzzle pieces but nothing else.
My daughter was diagnosed with autism and ADHD at 5. The biggest issue for her is meltdowns that can get physically aggressive. Public school was a serious struggle all through kindergarten and then in first grade was no longer an option due to constant classroom disruption, attacking staff, and attacking other children. What's worse is that she is absolutely racked with self-loathing and guilt afterwards. She is very bright and understands exactly what is expected of her and that she is not meeting those expectations, and she has a really hard time with it.
We have tried a lot of options to help her so far. She went to speech therapy from 3-4, is on medication for her ADHD, she sees an emotional counselor, and she goes to a school for kids with special needs so at least the adults there actually get what she's going through and are able to be compassionate with her (unlike the public school.) And I have completely changed my parenting style from how I was raised (negative reinforcement, guilt, punishment, etc...) to one that establishes boundaries with compassion and validation. I try to emotionally connect to her and make sure she knows she is safe and loved and heard and validated as much as I can.
But she is still struggling so much, so often. So many days melting down on teachers and students. I want to help her thrive. On her terms, to the best of her ability, in the world. But I don't know what else I can do to help her.
I see so much online about what NOT to do. Types of reinforcement and types of therapy that are not a good fit to help people deal with autism. But I would love advice about what else I CAN do for her. Right now just going to school is such a massive struggle for her. It's hard, man.
I have done research and reading and talked to my state's autism alliance and I still just feel like I am missing some giant piece of the puzzle. Lately I'm starting to think that piece is just accepting that this is as good as we can do and loving her as hard as I can while we get through it. But I'm just afraid that what she's going through (meltdowns at school, the guilt that comes afterwards) is too much, too emotionally hard, and that I'm not doing enough to help her. And I'm also worried that she's going to grow up and look back at this time and think that we failed her, that there was more we could have done to stop so many days from being so hard.
I would love some good, specific advice or resources. So much of what I see online is "what not to do" or very vague advice like "teach emotional health." I saw a video saying a certain type of therapy was like âteaching someone to walk on a broken leg instead of healing the leg.â But then it suggested no alternatives. Like please, give me an example. How can I both honor the autistic mind AND help set her up for success in the world?
(I am not a creationist, but I am a bored contrarian and I need to argue with somebody right now. Also, I'm trying to get a better grasp of the rules of phylogeny, so maybe y'all can teach me something.).
Reasons that I think the LUCA was an animal:
1:
Unicellularity is hard. We have this idealized conception of a unicellular microbe, where you stick a single cell on a petri dish and then overnight it becomes a million cells, but the vast majority of life can't do anything like this--certainly the LUCA couldn't, right? I think there would be an advantage to early life being multicellular, in that early life could "borrow" RNA/DNA/proteins with neighboring cells. Also they wouldn't need a full complement of molecular machinery if their neighbor can help out, even if their neighbor is a different species. Just like I can borrow my neighbor's stove if I'm making a special meal, early life probably borrowed very basic molecular machinery from the neighboring cell. And if any of their genes broke, they could maybe get a replacement from their neighbor? I think that it's hard to live all by your lonesome self if you're a primitive life form, so being multicellular is easier since you can rely on neighbor cells for various things and don't have to do everything yourself. I also think there's a very blurry line between a single multicellular organism and an interdependent community of unicellular organisms where none of the organisms could survive without the others. Many scientists agree that early life was like thisâan interdependent communityâand much life still is like this. But why should this type of community be considered to be closer to unicellularity than multicellularity?
2:
The nucleus seems like a leftover relic from the RNA world. The primary function seems to be to separate transcription and translation, but why would you want to do this in a DNA organism? Why are you separating transcription from translation if you already have this elegant system in prokaryotes of just having the ribosome and the RNA polymerase right next to each other doing their things almost simultaneously, much, much faster and more efficiently than eukaryotes. Why make everything ten times slower by evolving a nucleus when you could just not evolve a nucleus? Evolution doesnât plan ahead, and I fail to see how the nucleus is a favorable adaptation in the short term. On the other hand, a nucleus makes a ton of sense for an organism with an RNA genome because you'd need a way to separate your genomic RNA from your RNA transcripts so they could be regulated separately -- You wouldn't want to splice up or run a ribosome over your RNA genome, that would be a disaster.
3:
Having a nucleus would make it easier to evolve DNA. Whatever enzyme is deoxygenating the RNA backbone wouldn't run into the problem of accidentally deoxygenating the RNA transcripts. Since the transcripts are outside the nucleus.
4:
The nucleus could be an early form of cell specialization for a multicellular life form. If we think of the nucleus as a separate cell from the cytoplasmic space, I think the picture of early RNA life becomes clearer. Some cells/compartments evolve to specialize in replication and transcription -- these become the nucleus -- wheras other cells/compartments become specialized for translation of proteins --these became the cytoplasmic space, which ultimately engulfed the nucleus. In this primitive RNA organism, there would have been little distinction between replication and transcription. The cells of various sizes would have shared proteins, allowing the smaller cells specialized for replication/transcription to still benefit from the gene products being produced in the larger cells specialized for translation. The smaller cells would do a more faithful job of replicating the genome and not have to risk damaging their genes in the messy process of gene expression.
5:
Based on the multiple chromosomes in the nucleus, the first Eukaryote was a likely a synthesis of multiple organisms. Multiple organisms implies multicellular. If we look inside the nucleus, we see multiple, weird, x-shaped chromosomes, with a bunch of dumb hacks (centrosomes, telomerase, etc) to keep them from falling apart as they replicate. The bacterial system makes so much more sense for modern organisms -- just having a single circular chromosome: simple, elegant, effective. Again, the eukaryotic system seems like a molecular fossil from an earlier era where these features were actually necessary. I'd argue that the eukaryotic system supports multiple chromosomes because the original chromosomes were the RNA genomes of different interdependent organisms that lived in a multicellular community. Their RNA migrated into a single nucleus for better regulated and better synchronized replication of the community genes.
6:
The homologies between Porifera and Amoebozoa make no sense if Animals came from Choanoflagellates. It is widely assumed that multicellular eukaryotes evolved from single-celled eukaryotes, and this seems to be the case in land plants, at least, since they're so similar to algae which obviously came before land plants--but are we sure that it isn't the other way around for animals? Conventional wisdom is that animals evolved from choanoflagellates, and we see very similar cells to choanoflagellates in Porifera called choanocytes. BUT: Porifera (sponges) also have amoebocytes, which look and function a lot like amoebas. Amoebas are believed to be relatively closely related to animals, although not as closely related as choanoflagellates. Yet animals cannot have evolved from both amoebas and choanoflagellates, and choanoflagellates look nothing like amoebas. Isn't it an odd coincidence that amoebocyte cells in sponges are so much like amoebas? If animals came from choanoflagellates, then the similarity of amoebas and amoebocytes would have to be a coincidence. An alternative direction of evolution makes a lot more sense to me: Animals came first, and amoebas and choanoflagellates are separate lineages of reduced animals that have evolved down to only being a single cell. Other eukaryotes (such as fungi, algae and plants) could be evolved from these single-celled descendants of animals.
7:
Gene homologies between microsporidia and prokaryotes. Since microsporidia are very obviously reduced fungi, this makes no sense in the current prokaryote-first paradigm, so these gene homologies are handwaved away as being the result of horizontal gene transfer. But what if it isn't horizontal gene transfer? Microsporidia is a parasitic clade of fungi which has lost most of its genes, seemingly lost its mitochondria (are we absolutely sure they ever had mitochondria?) and shrunk to about the size of a bacterium. Its shrunk so much and lost so many genes that it actually is able to withstand mutations to very basic molecular machinery such as its ribosomes, which are very different from the ribosomes of other eukaryotes and seem more similar to the smaller ribosomes of prokaryotes. Perhaps prokaryotes are just even-further-reduced microsporidia that have lost their nucleus, circularized their DNA (which can also happen in cancer cells, google "eccDNA") and further streamlined their molecular machinery.
8:
We can learn a lot about the order of the clades from the type of ecological niches they currently occupy. For example: there do exist extremophile bacteria, so there's nothing inherent in bacterial microbiology that prevents them from evolving into extremophiles. So why do we see mostly extremophile archaea, but bacteria occupy almost all of the generalist, high productivity microbial niches? I'd argue: Probably, archaea had a head start in evolving specialized adaptations for extremophile environments. Probably, archaea came first. Imagine an archaeon existing before there were any bacteria, and it evolved to occupy all microbe ecological niches. Then bacteria came along in a new adaptive radiation with superior molecular biology. They were able to supplant archaea from most generalist niches but haven't been able to challenge archaea for extremophile niches for which archaea have specialized genes and specialized adaptations. And neither bacteria nor archaea seriously challenge eukaryotes for the larger ecological niches which require even more specialized adaptations. This to me implies that Eukaryotes came first, archaea came second, and bacteria are the most recent domain.
9:
Animals almost exclusively occupy the large, complex, predator niche. I'd argue that the large predator niche, of all ecological niches, is the one where the greatest advantage is given to the organism who evolves to fill the niche first. Because selection pressure changes a lot once the predator appears: Things that can't run away from the predator are forced to make themselves as unappetizing as possible. So they can't have complex proteins, since complex proteins = tastier. So how can any clade evolve into a predator if there already exists a predator clade that could eat it? The fossil record seems to think: It canât. Throughout the entire fossil record for which we have good records (since the Cambrian), the predator is always an animal. Never does a slime mold or a fungus something evolve muscles and teeth and start competing with animals for the predator niche. But this isnât 100% true -- you have Venus fly traps, I suppose? So thatâs one exception, the only one I can think of. Animal predators today have billions of years of evolutionary head start evolving such things as muscles, a nervous system, circulatory system, etc. If anything else other than an animal starts evolving complex structures or energy storage, it's only going to make itself tastier to an animal. The predator is also the niche that cares the least about the efficiency of basic molecular processes -- it doesn't need to be efficient when the world is its buffet. For this reason, I'd argue that the predator clade must have established itself very early. Probably the kingdom that occupies the apex predator niche at any given time is the absolute oldest lineage of multicellular life. Because long, long after all the original autotrophs have gone extinct, replaced with things that don't waste so much energy and have more efficient and streamlined molecular biology, the apex predator clade would remain on its throne, since nothing, I'd argue, would be able to compete with its evolutionary head start evolving so many complex adaptations for multicellularity. Are we to believe there was ever a time when the apex predator niche was something other than an animal? It's difficult to imagine. If that apex predator was a prokaryote, what is it about animal molecular biology that allowed it to overcome such extreme odds and supplant that prokaryote as the apex predator?
10:
The fossil record of animals before the Cambrian is probably very incomplete. The first complex animals in the fossil record (the cambrian explosion) seem very, very advanced already -- I think this is a representation that our fossil record is incomplete and animals are a much older clade than they seem. Since predators are rarer in an ecosystem, and may have been even rarer when energy was scarcer due to less oxygen in the atmosphere (early heterotrophic life likely breathed sulfur compounds), we may simply not have any good fossils of animals from before the cambrian.
11:
It's also possible that early animals simply weren't made out of the right material to fossilize. Maybe Archean-eon animals had no bones or anything like that and so they didn't fossilize, so we don't have examples of them. We can't assume that just because you don't find fossilized animals from ~3 billion years ago doesn't mean they weren't around then. And even if we did find fossilized animals from that long ago, they were probably so radically different from modern animals that we might misidentify them. For example, we have many fossils of strange creatures from billions of years ago, nobody knows what they are. Maybe they are animals? Example: Google âGrypaniaâ. Currently there is a debate on whether these are algae or bacteria. But they are quite large, and they look sortof wormlike, so, in my view, thereâs no reason they couldnât be primitive animals.
12:
Animals are slow reproducing but have the most sophisticated adaptations for multicellularity. The slower something reproduces, the slower it evolves, since thereâs less opportunities for mutations. So how did animals have time to acquire so many complex adaptations for multicellularity? They must be an especially ancient lineage, something that has been multicellular much longer than anything else â otherwise they wouldnât have had time to acquire so many complex adaptations for multicellularity.
13:
Phylogenetic trees based on bioinformatics suffer from "long branch attraction" artefacts -- where fast reproducing, simple, and numerous organisms group together at the base of the tree. This is a well-known problem for making phylogenetic trees. Since prokaryotes are so much more numerous and reproduce so much faster than eukaryotes, itâs natural that they would have the most genetic diversity, even if they evolved later. The appearance of prokaryotes at the base of the tree of life derived from bioinformatics algorithms may be a product of long branch attraction.
14:
Counterpoints on mitochondrias. Iâll admit that mitochondrias do look a lot like bacterial symbiotes, but that doesn't necessarily mean the original eukaryotes had mitochondrias. Once alphaproteobacteria evolved, it might have infected many lineages of eukaryotes simultaneously, since nothing had resistance to its infections yet. Maybe it impersonated the mitosome and supplanted its function, and did such a good job as a mitosome that the only surviving eukaryotic lineages are ones with alphaproteobacterial infections. Also, if we assume that bacteria are reduced eukaryotes, then many of the gene homologies for mitochondria associated genes could have been present in the eukaryotic LUCA, and perhaps they were used for regulating the mitosome which preceded mitochondrias. I think that the mitochondria is an interesting piece of the puzzle, but it doesn't conclusively demonstrate that prokaryotes came first.
âŠ.
I make ASCII phylogenetic tree for fun:
_______________________________________________Placazoa 1____LUCA_____________________________________________5_____Ctenophora _______Cnidaria ___Bilateria ______________________________________________Porifera _____________Choanoflagellatea _________Dinoflagellata _______Algae ____Viridiplantae __2___________________________________Amoebozoa _________________________________Fungi _3_______Microsporidia __4____Archaea ^ ______Bacteria (endosymbiosis into various eukaryotic clades) _____Mitochondria ^ (horizontal gene transfer from now-extinct RNA life forms to bacteria and archaea) ______________________primitive RNA life forms (extinct) 1: A community of highly interdependent organisms evolves into multicellular eukaryotic progenator with a DNA genome inside a nucleus. This hypothetical LUCA is a relatively large and complex heterotroph which fed on primitive RNA life forms. 2: First truely unicellular (non-colonial) organisms (independent living isn't easy!) 3: Extreme miniaturization 4: Loss of eukaryotic nucleus 5: Complex adaptations for apex predator niches (neurons, etc)
Everyone else in my life seems to have theyâre prayers answered and great things happen to them where their puzzle pieces all just fall into place and they are fulfilled and become content and happy with their lives. I pray and it seems to fall on deaf ears, all I have asked if God is that he forgive my sins and that he ends my life and kills me. Why has God given others in my life these great complex things that make them happy so why does he not answer my simple prayer to kill me.
My online âfriendâ, letâs call him Alex(14M), he keeps doing things that ruins our âfriendshipâ like, saying heâs gonna dox me, saying he is sending people to swat my house, saying that heâs gonna put my bloodline in âdangerâ and everytime i speak up he keeps saying âIâm sorry but Iâm unmedicatedâ as an excuse and I have to suck it up because I donât want to be the asshole that seems inconsiderate. He asked one of my real friend âIf you tell me his address I will do anything to be in your favorâŠ.â And my friend was like wtf. Heâs not gonna send out my address like itâs candy on halloween night. My friend immediately messaged me with screenshots of what has been sent to him. I saw them and I was obviously scared. I confronted him and he kept using his âbpdâ as an excuse which I donât even know if he even has. (He lies alot) which I will talk about now. He likes to lie about the littlest things up to major things. From getting alot of money on a block game to his father having cancer, or kidney failure, or he having cancer. He harrased a victim with sa, said âhope your boyfriend gets you pregnant and you miscarryâ and I have to sit there and cant say nothing because then I seem like the inconsiderate friend. I told him he cant keep using his bpd as an excuse and he said that he doesnt care. He said in the exact words âit was âniceâ knowing you even tho you dragged me down you piece of shit hating bastardâ I obviously erupted. Im not going to let someone try to provoke me when I know that I have no wrongings in this. Well atleast not as much as him.
Edit: He keeps saying that without me heâs gonna commit suicide which im guessing is manipulation and he keeps saying âif u need anything im here for you if im still around. Which i find absurd, cus first all this hatred towards me then he says this.. Im genuinely puzzled.
When solving a mystery, one has to make some assumptions if one wishes to go beyond a surface level solve attempt of From's mystery. Which effectively means, one must pick an answer to a clue one is fairly certain of, and use that as one might use a jigsaw piece to solve the next clue that connects to it.
For any interested, I share my opinion on what the key strands of clue clusters and the twisted threads therein that I believe need to be woven together into a narrative to form an origin story for Fromland and solve the show.
1. The first strand is historical figures from North American history (and the end of the War of the Roses), falling roughly on the dates on Tabitha's dream sequence. Some historical figures are given far more clues than others, suggesting they might later become characters on the show. In particular Caroline Dye's hoodoo magic, and Alma Hayes the strongwoman.
There are six threads in there as not every timeline will be explored in the series - the main ones are 1930s, 1880s, 1860s, 1770s, 1670s, and 1498.
1498 is by far the most prevalent and perhaps the easiest to start with. Most are from England and to a lesser extent, Italy/Venice, Scotland, Germany, Portugal, Spain, France, Burgundy, China, Iran, Iceland, Greenland/Newfoundland. It's also the best one to solve first, as the historical figures in the 1498 origin story are the archetypes that the historical figures in the other timelines mimic.
For example, I'm absolutely certain one is Richard Amerike - Sheriff of Bristol. There is a lawman/sheriff in every timeline - Boyd is the sheriff now.
Each new historical figure discovered in any timeline is a great puzzle piece. If you find out Emmett Kelly, the Hobo Clown is in the 1930s timeline, you can search for other "clowns" and discover Triboulet, the court jester in the 1498 origin story.
2. The second strand is the sequence of events in the origin story specifically. These clues are far more vague, and easier to explain what I mean by example.
Let's look at Kelly's head spiked to a tree with Boyd yanking it out instead of using the gun. The reasoning was: Kristi did not want Kelly to see or experience the gun, when Kelly is currently blind and the gun is a far better "experience" than the yanking. I contend this is quite a pointed clue that he's recreating a scene in the original timeline. In my opinion, a botched execution by a crossbow at a time where there were no guns to use.
There are threads within this strand. Two are practically strands of their own, with witch trial and torture methods and christmas / lent traditions from the countries of the various historical figures being the most prevalent. The traditions bit is a lot easier if you solve the origin story characters first, since you can then surmise which countries the traditions to look out for might come from.
3. The third strand is the mythology of the show. Ultimately, if one assumes North East Canada is where it all begins, you might make the leap it relates to the mythology related to that area. This has two main threads, the bogeyman, and the fairies. What I came to find were, there were clues pointing to practically every kind of bogeyman and fairy legend in that region. I was wondering if these were red herrings, or maybe it was all of them at once? It took me a long time to figure out what we're being asked to do here - but I figure there are 7 bogeymen and 4 fairy types the monsters and entity are mimicking, and a type of bogeyman and fairy that they really are.
4. Apotropaic magic - specific to the cunning folk of England. Witch's bottles and ladders, that sort of thing.
5. Medieval board and card games, as well as a few other adult medieval games, like stoolball. Main thread here is French tarot cards, but not their witchy meanings and connection to fortune telling, just the playing cards and what they look like. Other substantial threads involve Game of Goose and Pachisi.
Hi Everyone, I'm probably going to have a bunch of follow-up questions, so I appreciate everyone's help in advance, but for now, I'm going to try and keep it as simple as possible. I think I should be able to work out the other steps if I can just get past the first hurdle. Teach a fellow to fish, and all that.
Unfortunately, I can't upload sample data because the data is sensitive, so I'm going to use a made up example to help explain where necessary.
The End Goal: I am creating a metrics dashboard to display how well we are progressing towards our annual goals. I have one table with the metrics listed, along with the 2024 goal for each metric (numeric values). We'll call this the Metrics table. I also have two tables combined which contains all the data used to calculate the 'Actuals'. We'll call this the Data table. There are no fields that join the 'Metrics' table with the 'Data' table. I plan to create a dual-axis bar graph which shows Actuals vs Goals.
Since there are no matching fields between the Data table and the Metrics table, I plan to create a calculated field for each of the individual metrics, using data from the Data table. I will then create a calculated field named "Actuals" which will contain a series of IF statements based on the metric name. i.e., IF [Metrics].[Metric] = "Metric 1" THEN [Data].[Metric 1] ELSEIF [Metrics].[Metrics] = "Metric 2" THEN [Data].[Metric 2], and so on and so forth.
The issue I'm having is creating the calculated fields for each metric...
An Explanation of the Dataset: Let's say my data is about the delivery of fruit and vegetables. The two tables combined to make the 'Data' table are a 'Delivery Stats' table and a 'Metadata' table. The 'Delivery Stats' table lists the fruits and vegetables delivered, the date, the quantity delivered, the quantity that are rotten, and the % that are rotten. The 'Metadata' table lists every fruit and vegetable that we have ever ordered, and then lists the features of each fruit/vegetable. e.g., if it's a fruit or a vegetable, the colour, the country of origin, etc. Note: each fruit/vegetable is only listed once in the Metadata table, as the metadata is static.
The last piece of the puzzle is that I have a 'Metric Date' which is a calculated field. It shows the last available date from the previous month, based on the data available. So within my dataset, that date is March 29. The reason I am using a calculated field is so that the date can be dynamic based on the data available.
Where I'm Stuck: My first metric is 'Number of Red Fruit/Vegetables'. So I want to do a simple count of the number of rows where the Colour is listed as 'Red', but only on the Metric Date (i.e., March 29). And this is where I'm getting stumped.
I can create a table where I have Date and Colour in the rows, and then Total Fruit in the Marks, but what I need to do is create a calculated field that shows only the count of red fruits and only on the 'Metrics Date'.
What I've Done So Far: I created a binary calculated field called "Red" which uses IF logic to assign a 1 or a 0 to each row:
IIF([Colour]="Red",1,0)
I then created the 'Number of Red Fruit/Vegetables' calculated field which uses IF logic to SUM the "Red" column when the Date = the Metric Date:
IF [Date] = [Metrics Date] THEN [Red] END
But it's throwing out a number that's way higher than it should be. (It should be 224, but I'm getting 1,120). I can't work out what it's doing to get the higher count.
I think a large part of my struggle is because I'm still stuck in the Excel mindset of using a "COUNTIFS" function to get the total. I just can't for the life of me figure out how to do the same in Tableau.
Thanks to anyone who takes the time to read all this and can offer some guidance.
TL;DR: How to I create a calculated field that spits out a single count of all the records where the data meets multiple criteria located across multiple fields?
As the world faded away into nothing but a dark void, Tom felt the only mildly familiar sensation of magic flowing like a gentle stream. It wasnât much of a draw, but it was certainly noticeable.
âRight, best make this quick then,â he tried thinking to himself, feeling the flow peak as he did.
âWho is this? Make what quick?â an ethereal sounding female voice replied. It did sound a bit like how he remembered Joelina sounding. Though she did not exactly sound calm.
âUhm⊠Hello? Anyone there?â
âYes hello. Who is this? What must be done quick? Answer me at once!â
âItâs Tom⊠Is that you, Joelina?â
âYes of course it is! Stupid dragons taking ages, I have questions for you! So many questiiioooonssss...â
âYeah I figured that⊠Fire away I suppose.â Tom replied a little uncertainly as to just what he might be in for.
âFirstly! Did you read the letters?â
âI did yeahâŠâ
âDisregard them, I have learned much since they were written! So much more yes, cursed blessed knowledgeâŠâ
âSo you do know we have gone to space then?â
âWhat? No, I re-experienced the memory you had of the movie about the moon mission. It was evident on the second watching that it was trickery of the eye! Spaceflight is but a myth!â
âRiiight.â
âThen how have your kind visited space? And what of the gods above!? it was evident that the woman with the crystals was but a fraud!â Joelina explained with all the calm and restraint of a shoppingmall Karen
âWell the rockets to the moon, that did happen.â Tom attempted, doing his best to remain calm and diplomatic. âThe movie you saw was probably a recreation⊠Tell me, did things go wrong on that trip but they made it home anyway?â
âYes, do you know of what I speak? Ahr what am I proclaiming! of course you do it is your own memories, how could I forget.â
âYeaâŠ, you watched a movie about Apollo 13 I think. Good movie, and that all happened too. Like for real happenedâ
âI seeâŠâ Joelina replied, sounding rather unstable. âAnd what of the gods?â
âWe ainât got any. Well not in space at least.â
âImpossible!â
âNo, quite possible. Many still believe in gods though, but letâs not get into that too much. Itâs a right old mess.â
âNo, you must tell me what happened to the gods? Have they left you?â
âWell some think so, but no. I just think it all works a bit different for us. They might be a little more hands off.â
âBut the churches⊠and these religious warriors you did battle with,â the inquisitor all but muttered to herself, sounding like she was struggling to put pieces together. âDo Jesus and Islam fight for power then? no no, they would have long since lost the battles to the ancient gods of war the teachers spoke of⊠though why they were always naked eludes me yeeeesâŠâ
âNo, again we donât really have gods just floating around... Could we please talk about something else? Or is that all you wanted to know?â Tom tried, hoping he really didnât have to dive deeper into that particular subject.
âNo no donât you dare cut me off! I have seen what you talked of, nuclear fire and missiles, ships of the oceans and planes soaring in the skies. But is it not all fake? Surely it must be! It must be? It must beâŠâ
âI donât know what you saw⊠but we have ships sailing around. If youâve ever seen flying ships like you have here then thatâs fake I can assure you of that. We do have airships, but they look more like really big long balloons.â
âBut we could make such vessels, or someone could from times past. If you can visit the moon then surely you can make a ship for the skies!â
âNo no, we ainât got grav oil. Or dragon essence as I guess itâs called. That means no anti gravity, and that means weight is a very very big problem for anything you wanna make fly. Planes and helicopters are how we fly. Remember how I flew to Afghanistan on a big ass plane? Or when I learned to parachute later?â
âWhat is parachute? is it the ham from your times doing, vacationing? what has dried meat products got to do with flying machines of battle!â
âWooo easy now easy. I guess you didnât get that far yet. Uhm. Itâs a cloth kite you dangle from and then glide to the ground. Very good fun.â
âA cloth kite used to fly?... such strange inventions. Wait was there not a movie of with something of that nature? yeeee⊠there was a song. I liked that song⊠something something brains upon his chute. YeesssâŠâ
âYeah⊠Youâll know it when you see it. I have one actually.â Tom clarified trying not to get too weirded out.
âYou must demonstrate on a suitable occasion.â
âYeah⊠I do have a question too though,â Tom replied, letting silence reign for a short time. â...Your last letter was in Danish.â
âOh, uhm yes. I- I was having some difficulty separating what was real and what was not⊠I still am. Do not tell Glazz, she musten know the truth yet. She seeks to limit my excursions.â
âYouâve ended up like I did, have you?â
âNo no no, the effects do indeed recede as expected, everything is in good order⊠But I had to know more. So so much moooore.â
âMaybe you should cool it a bit. You never know when a brain snaps. Or how,â Tom tried, confident his advice would be ignored.
âThere is not time!â
âAnd why is that? How is it going in our beloved Inquisition?â
âMind your tongue, human! Things are progressing, but so are our enemies. Infiltrators have been caught, traitors within our ranks are making their moves. The reemergence of Rashan, attacks on mines, keeps and a daring heist attempt at a Royal Guard fortress! The game is afoot, we cannot delay.â
âYou canât overreach yourself either. Werenât you supposed to be winning over the rest of the inquisition right about now? Canât do that as a gibbering mess.â
There was silence for a while more after that. âGlazz sent you a letter? What did it say?! You may not keep secrets from me- wait not⊠I should confiscate her arm⊠she cannot write with her left. Yes far better plan, avoid upsetting him. And fill her pen with invisible ink. Yes very good.â
âNo, itâs just obvious to any idiot. But what about winter, wonât things slow down?â
âThey should, yet as autumn progresses it has only been picking up. I hope they too are running out of time⊠But time for what? I must know what they are planning. They might be behind schedule. But what SCHEDULE! sorryâŠâ
âWell youâre not gonna find the answer to that in my memories, now are you?â
âYou were sent by someone. You are here for a purpose. I must know this purpose. It will help me understand. The puzzle is large and much of the box kept from me.â
âAs far as Iâm concerned, Iâm here to help you guys get in gear. Thatâs a decades to centuries long sorta problem, not a couple of years. Sounds like this war will be in the couple of years category.â
âThen why now? Why did you arrive now?!â
âShitty luck? Sounds like 10 years ago would have been a lot better⊠Oh on that note, did you hear? We found something down below.â
âNo, Paulin would have told me.âJoelina dismissed, he could almost feel her turning her snout up and away from him.
âWell we opened the vault like 3 days ago,â Tom replied, quite surprised Paulin hadnât said anything. âWait yeah she can send you messages, no? She sent the message about what we wanted to buy too, didnât she?... How did she do that by the way? Why didnât you just have her ask me questions?â
âThat is not for you to know, and this is not for her.â
âReally? More secrets still? Come on, tell me or Iâll let you think flying whales exist.â
âI know those are not real. If they were, you would have harvested them long ago! likely for some deranged snack⊠or facial decoration.â
âTrue, but you get the idea,â Tom persisted, feeling like this was something worth pushing for. Why would Paulin not have let her precious Joelina know?
âVery well. This does not leave your mind⊠In the name of, what was it called⊠camaraderie. Paulin is in possession of joined paper. Messages may be written down and read by anyone with similarly joined paper. Unsecured. Originally believed to be fore love letters⊠dastardly studs and wenches using perfectly good magic for such trivialness⊠simply tie the message to a rock and throw it though the window. Most peasants cannot even afford glassâ Joelina trailed off, seemingly zoning out once more.
âYou have magical paper that can relay written information⊠and you donât fucking use it!?â Tom explaimed, not quite believing what he was hearing.
âNo, we do not know how to make freshly bonded paper⊠only more linked to all other paper in existenceâŠâ Joelina agreed. He could almost feel her looking at the floor in shame. âBut it is not as if you are infallible, why did you not bring one of these radios?â
âI uhmâŠâ
âWhy didnât you?!â
âI forgot,â Tom admitted, thinking back to his packing days. Of all the things that could have proven useful, that one might have been his biggest blunder.
âFor the love of all that is holy! You are our saviour?!â Joelina scolded, understandably so, but still.
âHey I never claimed to be smart!â
âI have lived your dreams. That is a lie! You very much claim to be smart!â
âFuck off, I know you are just a scared little insecure girl.â
âShe died 30 years ago!â
âWell I havenât gotten to that bit yet!â
âWhat in the devils do you mean?â Joelina questioned calming right down in a fraction of a second.
âIâve only had like three proper dreams about you⊠wait no, not like that,â Tom blurted out as it clicked just how wrong that sounded. Joelina didnât seem to care in the slightest though.
âThree? That is it!?â going right back to outrage.
âYeah⊠Wait, how many have you had?â Tom questioned. He rather wanted to know just how much she might know about him in addition to the memories she had already picked through when inside his head.
âSeveral a day!â the inquisitor exclaimed in reply.
âOkay, I can see how that would drive someone a bit mad.â
âI am not going mad!â
âDid Glazz say the same thing?â Tom questioned, quite certain he was striking a nerve.
There was no reply for quite some time, Tom feeling the headache growing as things grew tranquil once more. He could feel his breath. It was rapid, and his heart was pounding. He probably shouldnât do this for much longer. Thus he endeavored to break the silence.
âYou probably should listen to her you know.â
âNo! These matters are above her station!â
âHasnât she been in the Inquisition longer than you?â
âShe has yes. But she is no inquisitor. She is a body guard.â
âSeems like she is a wee bit more than that,â Tom pushed on. He didnât yet know how those two came to stick together, but it was clear they had been working together for decades by now. All the way since she was assigned to Harvik
âMind your own matters, human.â
âVery well, donât think I can keep this up anyway.â
âWe have barely been chatting! Where do the dogs come from?!â
âSelective breeding for thousands of years. But Iâm gonna go. Take a break, do what Glazz says⊠even if Jacky hates her.â
Yet more silence followed that, though it was brief and Joelina was the first to speak again.
âFine! In the interest of cooperation I shall let you rest. Wear the earring at all times, I shall be contacting you again soon.â
âI think Iâm gonna be the judge of that. Iâll put it on when I feel like it.â
âYou will do as I say!â
âYou need a nap and a bit to calm down. Iâll give you three days. Around noon. See yah⊠How do I get this thing off?â
âIâm not telling you,â Joelina grumped like a little girl. She really didnât seem quite like herself at all today. She had been the spitting image of restraint and arrogance before. The arrogance was still there, but the restraint had certainly gone.
âCome on, do I just try to cut off the magic or is that a bad idea?â
âIf you answer a question I might answer.â
âRight thenâŠ
Gimme gimme gimme aaaa-â
âJUST CUT IT! Farewell!â she called out loud enough Tomâs head pulsed and then there was blissful silence once more.
âHehe. That did the trick, right concentrate on that funny feeling aaan-â
__________________________________________________________________________________
After dinner had been rounded up, Dakota had given a brief address as to some of the news received. There wasnât much that hadnât already made the rounds at the tables during the dinner itself. The war had been expanding, recruitment had started in full in the cities, and if not for the rather special situation at Bizmati they could have expected their banners to get called by spring.
Rumors had it that the kingdom was preparing itself for counterstrikes the following spring, which meant training through the winter for many volunteers.
âAnd a lot of not so volunteers,â Fengi muttered as Dakota carried on with the address.
âYou can say that twice. At least the street rats might get something to eat and a place to sleep,â Tirox the trader escort added.
âI suppose that is true. Not a bad deal in winter time⊠I might even have taken it.â
âBut we must instead keep our minds on our home,â Dakota carried on, talking to the whole hall. âThere can be no mistake, we will be a target. We will be ready. They are getting bolder by the day it seems. It is not impossible they may attempt to take our keep before the winter comes. Or perhaps they will be waiting for spring. It is equally clear their forces are spread thin. We will weather such assaults, I have no doubt. But we must keep training. We must keep vigil. We cannot afford to be surprised or outmatched. I know you will all do your best. And tonight, we have no less than 4 dragons here. So breathe easy, have your snacks and your drinks. If the weather holds soon we will be finished with the warehouse and then we may make final preparations for winter. It is sure to be an interesting one for once.â
The hall replied with a half-discordant cheer, not overly enthusiastic unlike what Dakota had likely envisioned. The talk of them possibly getting attacked even before the snow came wasnât really that encouraging. But Dakota tended to speak her mind, and she was probably right. Bizmati keep would be a damn tough nut to crack. And to Dakotaâs credit she did seem to recognize she hadnât really managed to rile them up.
âDidnât you hear me?â she tried again in a slightly more humorous tone. âEat, drink, and have fun! And put those tables together, donât want you brooding in your corners.â
That did get a bit more of a reaction, as well as some good humored chuckles. People started getting up and set about moving the tables closer together.
It was a little rude to split up their guests in the same way as they normally did. Saph carried one of the benches over to the new spot, glancing around for any sign of Maiko, but there was no sign of him anywhere.
Feeling a little miffed, she sat down with the others as Ray came back with one of the small kegs of cider looking very excited. âWe should have a taste, right?â
âOh yes please!â Pho called out, Essy giving her a slight slap on the wrist.
âThis one is only for those who paid for it. You will have to do with whatever you bought. Or the ale Iâm sure they intend to serve.â
âAww man. Not even a sip?â
âOkay, maybe a sip,â Essy relented. âOh, I should get Koko his gift.â
âYou got him a gift?â Saph questioned with mirth in her voice.
âOf course, that is what people do for each other⊠you did get Maiko something, right?â
Saph felt her expression slip a little as she prepared to disappoint their chief people person. âNo, not reallyâŠâ
âAll that money and you didnât get him shit? Thatâs cold girl,â Pho laughed, clearly finding it hilarious.
âOh shut up, not as if I got something for Unkai either,â Fengi added, springing to Sapphireâs defence, though it seemed like the delivery had Fengi second guessing herself as well.
Esmeralda did look a little saddened by the news, but she was far too nice to say anything. Tirox however had no such filter.
âOh donât worry about it, just gotta go with a different sort of gift.â The diminutive guard laughed heartily at his joke. Udanti found it quite funny as well, and Pho certainly loved it. Bo just shook her head a little and went back to a small puzzle of some sort she had been working on, on and off, for most of the dinner by now.
âSo uhm⊠One mug each?â Ray questioned, having been left hanging at the keg.
âOh yes sorry, just the one, this stuff is expensive,â Saph replied, holding out her mug, Ray pushing it back down.
âOne moment.â And she produced a wooden mallet and one of the metal taps. It looked like one of Raulfâs, so it was probably old as faded dragonscales.
Ray gingerly placed it against the cork and raised the mallet as the table fell silent in anticipation.
With a whack the tap went in clean with hardly a drop spilled, and Ray breathed a visible sigh of relief. âRight there we go.â
There was a quick round of cheers from the table, and Ray started pouring servings.
âOh got yours open, have you?â the voice of Balethon came as the guard came walking up to the table, mug in hand and lizard on shoulder. âYou all know we are gonna have to work out who got the better stuff, right?â
âOh does it always have to be a competition with you, Balethon?â Saph questioned. She had just wanted to enjoy the cider.
âLook who is talking⊠And yeah of course we do! Just think of the bragging rights.â
Ray didnât look too thrilled, nor did any of the girls who had actually paid for the keg. The rest of the table seemed to think it was a brilliant idea, even as Balethonâs voice carried and heads started to turn as people started to mingle between the now closely together tables.
âIâll be the independent adjudicator!â Tirox declared, not receiving much attention as the full mugs started to get passed around. âOh come on. Iâll be fair!â
âShut it pipsqueak, youâll end up taking 10 rounds of tastings before you make up your mind,â Udanti scolded, though in good humor.
âI mightâŠâ the guy relented, looking to Balethon. âEy, by the way. Did you teach the brainlet any tricks?â
âSure, Skitters can do a few things.â
âAside from chasing the food?â
âYou know what I think he might yeah,â Balethon replied sarcastically, gently tapping the static lizard twice on the head. The lizard didnât do much save skitter about on his shoulder to face Balethonâs head, one eye pointing in whichever direction.
âThat thing just looks so dumb,â Saph thought to herself as Ray handed her a mug. âOh thank you.â
âOkay, Skitters. Up,â Balethon went, raising a claw into the air as if he wanted the lizard to jump. Or perhaps stand up. âUp⊠come on.â
There was no reaction from the lizard aside from it jerking to the left a bit, possibly having spotted a fly or something.
âWeeeell obedience might need some work,â Udanti chuckled. âHave you tried with some food in your hand?â
âSure, then he just tries to eat the hand. Come on, Skitters. Up!â Balethon tried again, doing the gesture once more. And this time the little lizard jumped into the air. The little legs stretched out, taking its pitiful excuse for wings with it, and it half-fell half-glided to the floor where it hit with all the grace of a 6 year old on his first lesson. The slightly fat lizard bounced once, then rolled over twice before coming to a stop, looking around confused.
âAaayyy! Thatâs a good boi,â Balethon went, going to pick it up again before someone stepped on it or it ran off under the tables. âAnd now you get a treat.â True to his word Skitters was fed a small piece of something or other which it seemed quite happy to snap up.
Fengi leaned in to whisper to Saph. âWas that the trick or did it just get sick of staying there?â
âI have no idea,â Saph replied, holding up her mug. âCheers though.â
âCheers,â Fengi replied as they clinked mugs.
âOh hang on now, wait for me,â Essy protested as Ray finished pouring her mug and started on her own, looking to the girls as she questioned âOh, also what about Jacky? Should we wait for her?â
âWho knows how long that will take?â Fengi replied, holding her mug impatiently.
âIâm sure she wonât mind. She is with Tom. Weâll let him have a mug as well,â Essy added with a reassuring nod, looking up to the high table. âOh but we are missing Lin!â
âOh right yeah she paid too⊠I canât remember, did Edita chip in?â
âI donât think so,â Sapphire replied, shaking her head as Essy got up to go fetch Linkosta. Balethon decided to take her place, a big grin on his face.
âSo what else is going on over here?â
âOh not much, hellooo little guy,â Pho went, trying to give skitters a scritching. In exchange he tried to eat her finger. âOh⊠I mean I guess it doesnât hurt.â
âOh yeah, he canât hurt a fly⊠well he can, but nothing more.â
âShame he wonât get any bigger either,â Udanti added, nodding sagely. âWould have made a good rat hunter.â
âNah⊠toe hunter though. Also where is the ale at?â
âOh Raulf and Wiperna are getting ale and some of the bubble beer.â
âWhat is bubble beer?â Udanti questioned, tilting her head.
âOh youâll love it,â Saph interjected, waiting patiently as she saw Essy and Linkosta returning to the table out of the corner of her eye. âItâs an ale but itâs all fizzy.â
âRiiight⊠Iâve heard of fizzy beers before.â
âOh yes, but this one is so much more fizzy.â
âItâs light and almost springlike.â
âLight ale? You mean for kids?â
âNo no no. Just trust us itâs good.â
âRight right, I trust you,â the archer replied, looking to Essy and Linkosta, who seemed to be looking for a place to sit. âShould we not just put two end to end rather than this scrunching up business?â
âYeah we should⊠Right get the craftsman table over here then. We donât wanna have to smell the guards,â Saph called out, holding up her mug.
âHey! That was uncalled for,â Balethon protested as Ray passed a mug to Linkosta. The girls all raised their mugs and had a sip, not willing to wait any longer. They all smacked their chops a little, looking down at the golden liquid. It was slightly fizzy too⊠and it tasted like the brew of the gods themselves. Ray was looking at them all visibly tense with anticipation and perhaps a twinge of fear.
âRay⊠You have not disappointed,â Saph declared, nodding her approval, a smile creeping onto her face once more.
âOh this is the best drink I think Iâve ever had,â Fengi added, taking another gentle sip.
Ray looked visibly relieved, her expression changing to one of ecstasy as she too took a sip herself. âOh itâs even better than I remember. Iâm glad you liked it.â
âLike it?! I love it!â Fengi cheers, Essy giving an appreciative nod to Ray before looking to Lin.
âSooo?â
âItâs very good⊠Do you think we could try and cool it down a little? Imagine this cold.â
âIt is often served cold, yes,â Ray confirmed, nodding her assent.
âIâll go get the powder!â Saph called out, getting up. âI have got to try that.â
__________________________________________________________________________________
The strange ethereal world that had seemed so all-consuming started to quickly fade. Holes grew as light and reality started seeping in, sounds and noise starting to build around him. âOom-Tom⊠Tom, are you okay?â came the familiar voice of Jacky as his eyes shot open and he blinked a few times as he returned to reality proper.
âYeah yeah, Iâm here⊠That is trippy, but hey, I think it worked.â
âHow many fingers?â Jacky questioned, holding up her hand.
â4. Clear as day.â
âPheeew. Okay look around, anything strange?â
Tom obeyed, sitting up a bit straighter and glancing about the room. âNnnnn, nope all good. Just like last time I used one of these.â
âRight, good. Now what did she say?â
âOh a bunch of stuff⊠mostly we chatted a bit about how sheâs going a touch mad. Even Glazz thinks sheâs falling apart at the seams apparently. She was also not happy I wanted a break.â
âOh donât tell me you have to do this every day from now on?â
âI said she had 3 days to get ready to try again. Hopefully sheâll have her case worked out by then.â
âHereâs to hoping⊠also how is your head? Does it hurt?â
âA bit, itâll go away Iâm sure.â
âRight,â Jacky replied, looking at him skeptically. âIf it gets worse, tell me. But dinner was served a while ago I think. And Iâm hungry.â
âMe too, letâs go.â
__________________________________________________________________________________
Well then, Joelina got her chat. She seems fine... I am sure she will continue to be a steadfast ally, within the walls of the inquisition for many weeks to co- I mean years, definetly years.
As always I hope you enjoyed the chapter, if not you know who to blame. I promise I won't cry to much if you tell me what was wrong... I promise.
Not really any news, other than fuck me I'm a busy boi, luckily I found the time to keep up with the writing yet, hopefully things will quet down soon so I can get back to begin a bit further ahead.
Untill next time, take care
Wiki and Art Gallery If you can't remember who someone is, want to read any of the side stories of fanfiction, or you just wanna watch some of the cool art that's been made for the story.
Patreon If you want to help get more cool shit made consider joining the Patreon, you also get chapters two weeks ahead of time.
HoH Subreddit if you want more stories from the HoH universe or are interested in writing something for this funny little world.
Discord if you wanna have a chat about the story or just hang out
First Previous