Oh yeah. Any manual data update has potential to go wrong.
Especially since in my exp the most common way to do this is to paste the new data over previous sheet in an excel, and hope all the formulas still work.
Kind of fine, but let’s hope there aren’t any new categories that weren’t there last month!
> Kind of fine, but let’s hope there aren’t any new categories that weren’t there last month!
if it does mess up your formulas hopefully it does it in a way that you actually notice!
hyperbole aside, I don't think it's entirely Looker's fault that business users can't seem to get the hang of it, but I think the delta between what users "should use" and "actually use" is large enough that the tool just isn't worth it.
Especially since in my exp the most common way to do this is to paste the new data over previous sheet in an excel, and hope all the formulas still work.
Kind of fine, but let’s hope there aren’t any new categories that weren’t there last month!