Average of an average help

[#1]

Lines	Orders	Lines/Order
10	2	5
100	50	2

With this data, I would make a chart and it graphs 5 and 2. Each company in my data model has a lines/order number.

I want an average Lines per order overall.

In this case, it would be 3.5 (2+5).

But now, I am using this

=Round(Median(Aggr(Count({<[Customer] = >} so_id)/ Count( {< [Customer] = >}DISTINCT SO_detail_created_by),Segment, Segment)))

But this gives me 110/52, which is not the number I am looking for. Segment is each customer's line of business, like lumber or construction or something.

Any help is appreciated.

[rubenmarin]

Hi Aaaron, not sure of what you want, maybe using Avg() instead of Median()

If it's not because of Median()... which value you expect from that sample?

[#3 · Accepted solution]

I solved this issue by creating another table in load script, and doing the division of the 2 fields into another field.