Is there a possibility to give expressions as X-Axis data in a Line Chart?

[Anonymous]

Suppose if I want to create a Line Chart, which has X-Axis values as X,Y,Z.

X,Y,Z are custom expressions like X=SUM(Sales1), Y=SUM(Sales2), Z=SUM(Sales3)

Is there a possibility to  give expressions as axis data?

[MarcoWedel]

Hi,

you can use the Aggr()-function in calculated dimensions to achieve this, e.g.:

=Aggr(Sum(Sales1), somedimensiontoaggregateover)

hope this helps

regards

Marco

[MarcoWedel]

Hi,

one example:

expression:

=Count(DISTINCT customerID)

calculated dimensions:

1st chart:

=Aggr(Sum(Sales), customerID)

2nd chart:

=Dual('$'&Replace(Class(Aggr(Sum(Sales), customerID),10),'<= x <','-'),Class(Aggr(Sum(Sales), customerID),10))

hope this helps

regards

Marco