Skip to content

Instantly share code, notes, and snippets.

@RadekMolenda

RadekMolenda/query.ex

Created February 9, 2018 16:10
Show Gist options
  • Save RadekMolenda/3d12cd0f3314328f78183673cfda2a02 to your computer and use it in GitHub Desktop.
Save RadekMolenda/3d12cd0f3314328f78183673cfda2a02 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.ex
from(t in "ticks",
select: %{interval: fragment("time_bucket('3 hours', ?) as interval", t.datetime), avg: avg(t.value), count: count(t.value)},
where: t.sensor == "H2S",
group_by: "interval",
order_by: "interval"
) |> Repo.all
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment