segmentation chart

[gauthamchilled]

do any one have idea how to create a chart to show segments based on the profit and revenue?

high revenue, less profit

hight reveneu,high profit

less revenue,less profit

less revenue,high profit

above are segments.

i have fields like revenue, and profit.

anyone suggest?

Gautham

[Anil_Babu_Samineni]

Can you please provide sample, meantime please explain more

[gauthamchilled]

bump

[avinashelite]

Is that segments are static ?? if that is the case one easy way would be is to add it as a background image for a chart and use for the analysis

[effinty2112]

Hi Gautham,

                    I would try a scatter chart with dimension Customer  (or whatever is appropriate in your data model) and these expressions. Add a couple of reference lines at x=0.5 and y = 0.5 to divide the chart into the four quadrants you're interested in.

X=

(Sum(revenue) -min(TOTAL Aggr(Sum(revenue),Customer)))

/

(max(TOTAL Aggr(Sum(revenue),Customer))-min(TOTAL Aggr(Sum(revenue),Customer)))

Y=

(Sum(profit) -min(TOTAL Aggr(Sum(profit),Customer)))

/

(max(TOTAL Aggr(Sum(profit),Customer))-min(TOTAL Aggr(Sum(profit),Customer)))

Cheers

Andrew