4 ms·
One can also use the sql SUBSTRING function to actually draw horizontal ASCII-art bar-charts in order to eyeball anomalies. Use a WITH sub-query to find the min
by tabtab 6y ago
One can also use the sql SUBSTRING function to actually draw horizontal ASCII-art bar-charts in order to eyeball anomalies. Use a WITH sub-query to find the minimum and maximum range to normalize bar width range.
For larger data-sets you can group them, such as finding the min, max, and average for each given month, and then graph them using different bar symbols: M=min, X=max, A=average. Once you spot an odd month, you use the original detail version to study that month further. (Make sure you display the bars using a fixed-width font, such as Courier.)
2020-01 MMMMMMMM
2020-01 AAAAAAAAAAAAAAA
2020-01 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
2020-02 MM
2020-02 AAAAAAAAAAA
2020-02 XXXXXXXXXXXXXXXXXXXXXXXXXXX
2020-03 MMMMM
2020-03 AAAAAAAAAAAAAAAAAAA
2020-03 XXXXXXXXXXXXXXXXXXXXXXXXXXX
Etc...