Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a stacked chart with has two dimensions.
Order Month and then a sum of the spend to group by bands
= Aggr( if(Sum(spend)<3000,dual('0-3k',1), if(Sum(spend)<=10000,dual('3k-10k',2), if(Sum(spend)<=100000,dual('10k-100k',3), if(Sum(spend)<=300000,dual('100k-300k',4), dual('300k+',5))))),OrderNumber)
I then have an expression sum(spend) which gives me a stacked chart showing the amount of spend by the amount of the order. I want to be able to divide this by the total count of OrderNumber.
Any ideas ie if I had three orders, two at 20 and one at 10. It would do a bar 20 / 3 and then stacked on top 10 / 3??
How about sum(spend)/count(Total ordernumber)
May be just this
Count(TOTAL OrderNumber) or Count(DISTINCT TOTAL OrderNumber)
I tried sum(spend)/count(Distinct Total ordernumber) and the result is much to low?
How about sum(spend)/count(Total ordernumber)