Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

shared grafana org for cargo-bins #279

Open
alsuren opened this issue Sep 8, 2024 · 0 comments
Open

shared grafana org for cargo-bins #279

alsuren opened this issue Sep 8, 2024 · 0 comments

Comments

@alsuren
Copy link
Collaborator

alsuren commented Sep 8, 2024

          Data has moved to a different org which uses infuxdb iox (which doesn't support dashboards yet). I will delete the old one and re-invite everyone to the new org.

I have also made a public dashboard at
https://alsuren.grafana.net/public-dashboards/12d4ec3edf2548a1850a813e00592b53 (which I will also move soon).

Originally posted by @alsuren in #165 (comment)

Unless grafana wants to give us an enterprise org, I will probably just make a new email address cargo-bins@gmail.com or something and set that up with a grafana account.

The dashboards from influxdb iox are a bit non-existent, but I have the following snippet in their data explorer if you want to do some messing about with the data:

https://us-east-1-1.aws.cloud2.influxdata.com/orgs/d44c7fc1cf1e3ea5/data-explorer?fluxScriptEditor

-- If you stumbled across this saved script in data explorer, you need to:
-- * disable SQL Sync
-- * select Bucket: cargo-quickinstall
-- * select Measurement: counts
-- * hit RUN
-- (the UI for this is a bit shocking).
--
-- I will make a shared grafana dashboard soon, but for now you can explore
-- the readonly one at:
-- https://alsuren.grafana.net/public-dashboards/12d4ec3edf2548a1850a813e00592b53

SELECT
  date_bin_gapfill(INTERVAL '10 minutes', time) AS time,
  crate,
  -- TODO: divide through by the interval to make this into a rate instead?
  sum("count") AS count
FROM "counts"
-- TODO: does influx ui give us variables for the start and end of the range,
-- like how grafana does?
WHERE time >= now() - interval '1 day' and time <= now()
GROUP BY 1, crate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant