Comment on Please no, just stop
luciferofastora@feddit.org 2 days agoA Data Analyst’s reading of your comment:
I am misusing Google Sheets to plan my character builds in Final Fantasy Tactics
Oh?
I have entered all the information in the sheet by hand
Uh-huh
and it is mostly text
Eww
This information cannot be put into a graph of any kind.
Phew
People asking me to turn text into graphs are the bane of my life. Well, one of many banes, really.
Axolotl_cpp@feddit.it 1 day ago
I wonder those people what expect those graphs to look like 😭
luciferofastora@feddit.org 1 day ago
Well, to be a little charitable, sometimes it’s text with numbers in it. I just need to figure out how best to extract the numbers from unstructured text, which is mostly tedious to validate.
Other times it’s text where there are supposed to be numbers, like the dates on invoices, which leads to really funny mixups when we look at the revenue per supplier and someone asks “Hey, we didn’t bring this supplier on until 2019, why are there revenues for 2012?” And the answer is “Because your invoice date is a manually entered text field and if you’re a quick typer, 2021 and 2012 are really close together.”
And then some times it’s questions like “How many customer service tickets do we get about X”. If X is a specific product name, odds are a simple full text search for the term gets most of them. If X is a general thing like “Office supplies” it becomes a nightmare really quickly.
Axolotl_cpp@feddit.it 1 day ago
Ooh, i see