Hi all, I released the “Box and Whisker / Boxplot Charts” plugin – a great way to add a horizontal or vertical boxplot chart to your app. The plugin automatically calculates the minimum, q1, median, q3, and maximum values based on the list of data points you give it for each series.
Note: the Box and Whisker chart is also available in the Simple Charts plugin (which is an entire suite of 19 plugins)
Here is a quick demo:
Let me know if you have any feedback or questions!
Alex TechBlocks
Hey Alex - having some trouble wrangling the data in my DB into the correct format for this type of boxplot graph and hoping you might be able to lend a hand!
I think it should be simple enough, so will do my best to explain-
simple data structure, with each entry in my DB having a date and a numeric value
want to group my data up by month (x - axis)
then boxplot all the values submitted in that month
all goes well, up until when I’m trying to format the data for each given month as a comma separated list, then to join all of those lists into a semicolon separated list (for the y values)
can also be months where users submit zero entries, so that also has to be accounted for
hoping you can help, and that I’ve given enough detail to explain the issue!
Cheers,
Lee