Find average from multiple variables

[Anonymous]

Hello

I am looking at multiple variables which have a similar field

example.

A     B     C

1     d     5.0

2     e     6.0

2     f      2.0

3     g     5.0

3     h     3.0

4     i      1.0

4     j      8.0

4     k     7.0

Right now I can find the sum of 1 as there is only one so the sum is 5.0

I want it to eventually show

1 - 5.0

2 - 8.0

3 - 8.0

4 - 16.0

I think i could do it by using an expression but not too sure

If anyone can help it would be appreciated

[Anil_Babu_Samineni]

Why not simply Sum(C)

[vishsaggi]

AS Anil suggested use straight table chart with Dimension as A and Expr: Sum(C) you will get as below.

A	Sum(C)
	37
1	5
2	8
3	8
4	16

[Anonymous]

Hello

Sorry I made a mistake

I want to be able to transfer these details to a map which uses A to map the locations Area onto

Right now it shows A details on the map but all the other areas are blank

[mbrdenmark]

What kind of "map" are you referring to?

What if you use Aggr() as part of your expression to force just one value by each group?

Aggr(sum(C),)

Alternatively you could create a new table with the aggregated values in your load script.

Load

     A,

     Sum(C) as C

Resident YourTable

Group by A;