I'm attempting to create multiple boxplots in a single chart with a non-existing dimension (=1), as a dimension is not relevant for my analysis (it should simply show max/min/quartiles of all data).
Imagine data as follows (sorry, I can't seem to get the table function to work).
My goal is to create a boxplot-chart which contains three separate boxplots (stacked on top of one another, perhaps with labels in between), one for DaysToShipment, one for DaysToInvoice and one for DaysToPayment. However my dimension is the same (none, thus a calculated dimension as =1), which is confusing me a lot.
Can I maybe handle this by creating a custom dimension with a few values (e.g. 1, 2 and 3), and attaching an expression which is to be limited to a dimension-value? Or is this not possible with a calculated dimension?