Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why not simply Sum(C)
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 |
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
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;