Set analysis help

[madhuqliklondon]

I have columns :

[customer NO]

[order number]

[total amount]

[date]

[country]

what I am trying to get is Per month How many  distinct customers( because one customer may order couple of times with different order number) , how many orders are there under £20 and how many are over £20 , total revenue and average order value

some thing like below .

|  

group	total customers	total orders	£total revenue	£aov
under £20	98721	13587	254712.23	18.74
over 20	12847	19587	878587.23	44.85

[madhuqliklondon]

Hi Sunny ,

when I use those expressions , it is counting single orders as one and its taking avg of that order only. I was trying to do Total distinct customers, total no of orders and all order total revenue and the avg of revenue for selected month

[sunny_talwar]

Did you use this as your dimension?

Aggr(If(Sum([total amount]) < 20, 'under £20', 'over £20'), [order number])

[madhuqliklondon]

[madhuqliklondon]

Hi Sunny ,I have clicked on amount in user Dimensions and added.

[sunny_talwar]

Not sure I understand... would you be able to share a sample?Preparing examples for Upload - Reduction and Data Scrambling

[madhuqliklondon]

Hi Sunny got it, I never seen top of the column where it is giving totals. Is there a chance we add Dimension to search box like under £15 and Over £15 ? like we add month, year etc..

[madhuqliklondon]

To multi box I mean.