Forum Discussion
Solved
Weighted average in Azure Log Analytics
Hi everybody, I'm new in Azure Log Analytics /KQL/ Language that AppInsights uses How can i calculate weighted average? Thank you
- this is super weird. i had done the same thing with 'by Week' stuff before I replied to you.
and It didn't work. there was some mistake with 'By'.
and now it works! ha-ha
Thank you, Clive! You helped me a lot!
How about this?
The screenshot really helped, however you could have pasted the query and a line of data into this message as text, to save anybody having to re-type it, copy & paste is easier :-) This just helps us to help you faster, especially on a complex query or dataset. I often add a line at the end of a test query "| limit 1", I can then copy the results of one line and column headings
// = (20 + 40 + 40 + 90 + 90 + 90) / 1 + 2 + 3
let t = datatable (Value:int, Weight:int, Week:string)
[
10,1,"2019-02-25T00:00:00.000",
10,1,"2019-02-26T00:00:00.000",
20,1,"2019-02-25T00:00:00.000",
40,2,"2019-02-25T00:00:00.000",
90,3,"2019-02-26T00:00:00.000",
];
t
| extend sumvalue = (Value * Weight)
| summarize weighted_avg = (sum(sumvalue) / sum(Weight) ) by Week
this is super weird. i had done the same thing with 'by Week' stuff before I replied to you.
and It didn't work. there was some mistake with 'By'.
and now it works! ha-ha
Thank you, Clive! You helped me a lot!
and It didn't work. there was some mistake with 'By'.
and now it works! ha-ha
Thank you, Clive! You helped me a lot!
Excellent, I'm pleased this is working for you now. All the best, Clive