1 Reply Latest reply: Jul 2, 2015 2:44 PM by Marcus Sommer

# Regarding spacing of dimensions in Trendline Charts

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.

• ###### Re: Regarding spacing of dimensions in Trendline Charts

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