ahhhh this is so cool! Finally decided to play with #QuartoPub dashboards (https://quarto.org/docs/dashboards/ ) and ObservableJS to automatically grab data from multiple Google Sheets and plot/show the data. No need for Shiny or anything—refreshing the page gets the latest data!
@andrew how hard was it to pick up the OJS to make this work? What prereqs did you already have covered that might make it take longer for someone else? I'm trying to decide if I should add this to my toolkit. It seems reallllllly likely, but I don't want to overcommit myself.
@jonthegeek@andrew If you look at Andrew’s previous toot boB Rudis gave him some ref material.
I didn’t have any prior JS experience and was able to make some OJS plots last year after watching a few hour-long intro vids by @allison_horst on the Observable YouTube channel. There are templates for different plots in Observable notebooks. And you can convert R data sources to OJS ones too, so no need for a JS dplyr-alike such as Arquero https://quarto.org/docs/interactive/ojs/
@jimgar@jonthegeek@allison_horst@hrbrmstr I'm currently using it only for plotting bc I'm afraid of figuring out all the data processing stuff, so I do that in R (hence the {plumber} API), but if I were smarter, I could probably just grab the Google Sheets CSVs directly with OJS, clean up the data, and plot it all in one live document
Next up, move all the data processing to a {plumber} #rstats API instead so that I can get data from both Google Sheets and Goodreads RSS (they have no API 😭) and show it all here simultaneously
Add comment