Forum Discussion

Tal Feinberg's avatar
Tal Feinberg
Copper Contributor
Jan 17, 2018

total a column in OMS

Hello,   How can I sum a column? I have each row dcount with number of customers and I would like to know what is the total of customers. I want to present a new row with the total number of ...
azure monitor
Query Language
Tal Feinberg's avatar
Tal Feinberg
Copper Contributor
Jan 17, 2018

Hi Noa,

 

Thanks, but when I do this

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

Its the only thing that displayed.

I want to continue and display all the results + the total in the same table/view.

 

Ketan Ghelani's avatar
Ketan Ghelani
Former Employee
Jan 21, 2018

Just keep in mind, that you cannot really sum a dcount, unless you know that each row is actually is mutually exclusive.  If you can expand on your scenario there could be other options (for e.g. you may have to use dcount_hll and hll_merge )