Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
you can use the Aggr()-function in calculated dimensions to achieve this, e.g.:
=Aggr(Sum(Sales1), somedimensiontoaggregateover)
hope this helps
regards
Marco
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