Uff, data downsampling can be a weird problem sometimes!
Averaging over regular-spaced data is fine, but when you have short, sharp spikes in-between lower frequency samples, that can lead to very werid behaviour.
Picture no. 1 shows awkward graph behaviour, resulting from averaging over the leftmost edge of a sharp spike.
#timescaledb, luckily, has tools to fix this. Using their `first` and `last` operators to extract the edges of each time bucket (generated with `time_bucket_gapfill`), it's possible to "fill in" buckets without any samples in them to use the edge of an adjacent bucket. This ensures that edges of sharp spikes remain preserved.
Picture no. 2 shows the exact same data but with a bit of edge preservation done. The data looks much closer to the truth with almost no extra points plotted!
Something for the #dataviz people maybe? ;)
Work is proceeding nicely at the #wendelstein #fusion #experiment!
The arc detection boards are due to being tested tomorrow, after the #data #server was successfully moved to a permanent virtual machine! More news on that soon.
For now, have another screenshot of a new, gorgeous #grafana dashboard for the devices. We figured out that you can use repeats on entire rows, which is wonderful for what we want to do!
I suppose it's time for an #introduction as well!
We're Xasin, Neira and Mesh, a bunch of furry nerds, enjoying their OpenSource shenanigans on side projects such as a DIY Smart Home, while working on sensor and monitoring equipment for science!
---
In regards to our scientific career, we are finishing up an M.Sc. in Energy Technology, with the intent to delve deeper into topics related to #nuclear powerplant design.
Currently, we are pursuing an internship at the #wendelstein #fusion experiment, where we are developing a fast power loss detection system of the ECRH-Heating of the plasma!
Attached below is a screenshot of one of the #grafana panels for the sensor system :>
After that, we have a Technical Studentship at #cern planned, where we will get the chance to work on the Magnetic Protection system for the #HighLuminosity upgrade.
On this account, we'll be posting science-related updates about work and other topics, so currently about the Wendelstein.
There's another account that will feature more of the personal tinkering at @xaseiresh@fosstodon.org :>
It is lovely to meet you all!
Bunch of dragons hiding in a labcoat, studying M.Sc. Energy Technology at the Leibniz University in Hannover.
Intern at the Wendelstein W7-x Fusion experiment designing an Arc Detection system.
Starting at CERN as Technical Student next February on the Magnetic Protection Systems for the upcoming High Luminosity upgrade!
Aiming to work in nuclear power technologies and sensoring and monitoring equipment.
This account will be used to keep in touch with the scientific community, and to post about science-related work shenanigans and other items.