I frequently have to plot frequency of occurrence of values using varying window sizes and it is frustrating apparently not to be able to do it in Calc without having to pre-process the data in some way. Does anyone have a solution? Is it a feature we can expect “real soon now”?
My dataset sizes can vary between a few objects up to hundreds and beyond and I need to be able to adjust the “bucket” size. In theory it should be straightforward…
PS I did actually write a Python program to do it, but it required exporting, reformatting etc etc before I even got to starting the plot.