Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a trend-line chart with age-buckets as dimensions. However these age buckets are not for uniform width.
First four buckets are built at an interval of 30 days whereas rest are built at intervals of 60 days and 120 days.
I would like to place these age buckets proportionately to the width of the bucket
For eg: the table is somewhat like this :
AgeWidth Age Account#
0-30 28 XX23
0-30 15 XX44
30-60 50 XX64
* * *
* * *
* * *
* * *
* * *
60-90 75 XX65
90-180 87 XX64
Age and Age Bucket are expressed in terms of days.
Now I want to build a chart with AgeWidth as dimension on X-axis and counting the number of accounts falling under each bucket
However in my chart I want to place the Dimension values to be placed proportionately based on the width of the bucket of AgeWidth
lets say
the distance between
buckets 30-60 and 60-90 is of one unit
then between 60-90 and 90-180 should be of two units.
I think this isn't directly possible. Maybe you could get it if you used two identically count-expressions and set by second expression the background-color (hit on + sign) to transparent if the dimension-values are 30-60 or 60-90. Maybe in this way: if(match(AgeWidth, '30-60', '60-90'), argb(0,0,0,0), blue()).
- Marcus