is it possibile to use aggregate function in text object?

[#1]

Hi ,

I created charts i want to use aggregate funtion in  text object is it possible aggregate function  use in text object?

           pls tell me out this is interview question.help me.

                         thankyou,

regards

madhu

[tresesco]

Yes.

[#3]

For use sake or testing , aggregate function can be used on any object.

Aggr() function as making a temporary table.

aggr(expression, dimensions) but we use it mostly in chart to calculated value of an expression over a dimension.

[sunny_talwar]

Yes it is definitely possible to use the Aggr function, but it needs to be prefixed with another function such as Sum/Max/Min/Only/Concat/Avg.... So something like this would give you a result in a text box:

Sum(Aggr(Sum(Sales), Vendor, Region))

where as this won't work in a text box:

Aggr(Sum(Sales, Vendor, Region)

I hope this will help.

Best,

Sunny

[#5]

thankyou tresesco. the question actually asked interview person to me .I give answer to that person  yes aggr() use in text box

[tresesco]

That's good. Better would be, if you try some practicals on the same and try to grab the concept rather than just being happy with  - 'I gave the right answer', because in future you might not just be asked that simple straight forward question in the interview or in the real life projects. So my piece of advice would be to learn it.