Only function

[Anonymous]

I have chart includes id wise value i.e. only(value)

I want to present the same value in textbox .how we can do that.

[sunny_talwar]

Is this a single value? Then use Only(value) or just value... if there are multiple of these values do you want to sum them? avg them? concat them?

[Anonymous]

I tried sum function it gives wrong result as it has multiple values

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Only(value), id))

[ger_alegria]

Use the same expresion Only(Value)

If you have more Values and are num values you can try with max(Value), sum(Value), avg(Value).

If you don't vave num values try with fields functions.

[Anonymous]

thanku very much

[Anonymous]

In my real scenario , I have to implement the same using calculated dimension i.e. value list

if I directly use your expression it correct result ,

But if I defined the condition that it should display the value for  4th dimension defined in valuelist it give wrong result

[sunny_talwar]

May be add NODISTINCT when using it with ValueList

Sum(Aggr(NODISTINCT Only(value), id))