Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to run an analysis that has Customers and Sales Amount and break the Sales into quartiles. I would like to create a box plot to show what the quartiles are across ALL customers. However, if I use the box-plot wizard then I am forced to have a Dimension and Aggregator so then it breaks down the data by Customer.
How can I create a chart to show what the quartile ranges are for Sales Amount, across ALL customers? If box-plot isn't the best method for this, then I'm fine with other charts too.
Easy fast trick
LOAD * INLINE [
F1
dummy
];
And then use F1 as dimension