- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
segmentation chart
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please provide sample, meantime please explain more
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
bump
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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