total a column in OMS

Hi Tal,

To only get the sum of the dcount value, you can do something like the bottom line here:

Update
| summarize dcount(Product) by Computer
| summarize sum_dcount=sum(dcount_Product)

To add the summed value to each row, you can do this:

let summed_dcount_products_by_computer=
Update
| summarize dcount(Product) by Computer
| summarize sum_dcount=sum(dcount_Product);
Update
| extend summed_dcount=toscalar(summed_dcount_products_by_computer)

HTH,

Noa