This message was deleted.
# helps
Slackbot
05/24/2023, 1:53 PMThis message was deleted.
f
Fabian Iwand
05/24/2023, 2:00 PMYou'll have to provide more context, I'm afraid.
d
Dylan Omran
05/24/2023, 2:00 PMOk, thanks. Have to do the school run now so will do that later 👍
Dylan Omran
05/24/2023, 4:10 PMThis is the notebook:
https://observablehq.com/d/d65648172da5ead6
I attached the file performance_21_22.json. I have a data table cell called 'data' which changes a few of the data types and gives people a way to see all the data. In the charts I'm creating I want to jitter the points along the X axis. I've been doing that in the charts themselves using Math.random().
Now I want to add the jitter value to the source data; either the json or the data table. When I tried to do it with RAND() in SQL I got an error message: Catalog Error: Scalar Function with name rand does not exist!
Perhaps I've confused things using SQL to wrangle the data? My javascript data wrangling isn't great so I was trying to avoid that.
f
Fabian Iwand
05/24/2023, 4:13 PMIt's called
random()❤️ 1
d
Dylan Omran
05/24/2023, 4:14 PMOK, now I feel a bit silly for not just trying the full word 🤦♂️ Thank you!
😁 1
f
Fabian Iwand
05/24/2023, 4:17 PMI would always recommend to refer to the docs regardless. Prevents getting gray hair over small API differences and often teaches you about adjacent functions that may prove even more useful.
👍 1
Fabian Iwand
05/24/2023, 4:18 PME.g. two rows down
setseedd
Dylan Omran
05/24/2023, 4:23 PMI really do need to read more in depth about Observable and Plot in general. Sometimes the urge to 'do' rather than 'learn' gets the better of me
f
Fabian Iwand
05/24/2023, 4:27 PMI often find myself at the opposite end. I usually try go get a broad overview of the tools at my disposal, which is a great way to procrastinate the actual work while feeling productive. 😅
But on the upside it actually teaches me about what's available, so that I have an easier time searching solutions to my problems.
🙌 1
d
Dylan Omran
05/24/2023, 5:21 PMAll things being equal I prefer that approach. But I'm trying to build a portfolio and do some hands-on work instead of just being a Product Owner who watches others doing the clever stuff 🙂