Script Wise Sum

[NavinReddy]

Hi All,

How Can we done Script wise Sum ,i know about the Dashboard we can able to apply sum function

Plz explain me how can we do in Script wise

Thanks in Advance

Niranjan

[sivarajs]

Sum aggregates towards dimension in chart ,while in sciprt we need to use group by field name for the aggregation

Load sum(sales)

from table.qvd group by ID;

If you are loading all the fields while summing you need to give all the fields in group by function.

So it better you always calculate in seperate load and field you are going to aggregate like the above example.

[NavinReddy]

Hi Sivaraj ,

Thanks a lot its helpful for me

Thanks & Regards

Niranjan

[NavinReddy]

Hi Sivaraj ,

I tried but example is not working will you please give

any other example

Thanks in Advace

Niranjan

[amars · Accepted solution]

Hi Niranjan,

Write it in this way,

Load ID, sum(sales) 

from table.qvd group by ID;

so the above will give sum for each ID,

If you do not have any Group by Clause , u can simply write,

Load sum(sales) from table.qvd ;

For more please see the file attached

Amar

[sivarajs]

Check the attached file

[NavinReddy]

Hi amars,

Thank you very much its working fine,nice explanation amars

Thanks & Regards

Niranjan

[NavinReddy]

Hi Sivaraj,

yes it is also working fine,great job

thank you so much

Thanks & Regards

Niranjan