Trying to impress the boss with a fancy SPC chart for monthly sales that can be filtered per product.
It's a line chart showing count of invoices (Or sum of revenue) per month. So first I need to add a line showing the average for all the months (A plain horizontal line, but it needs to adjust depending which product I filter on.)
Next is a calculated line (LCL=Mean-3*stddev)
Every time I have tried it just sees the invoice numbers as individual numbers and gives an average of that, rather than an average of the count per month.
I can easily put in fixed lines for all data, but I specifically want something that will adjust depending on the filter applied. If I can add a banner card that shows the actual calculated number per filter it will also help a lot.
Then I also need a way to sort products by a count of all invoice numbers in a bar chart. Is that possible?