Topic: How to Calculate Running Total in Kusto
In this video we are going to learn
about row underscore com sum function this function calculates the cumulative
sum of a column in a serialized row set that means we can find the running
total, Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns. A Kusto query is a read-only request to process data and return results.
// row_cumsum() - Calculates the cumulative sum of a column in a serialized row set.
//create Table and Insert Sample Data in Azure Data Explorer DB for Testing
.drop table TotalSale
.create table TotalSale (
id: int
,SalePersonFName: string
,SalePersonLName : string
,ProductName : string
,ItemsSold : int
,SoldPrice :real
,SoldDate: date
,City : string
,State : string
,Country : string
,Region : string
)
//Insert data
.ingest inline into table TotalSale <|
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe
9,Petra,Henry,TV,10,5000,2015-04-08,Paris,Île-de-France,France,Europe
3,Christy,Ladson,TV,3,1600,2015-04-02,High Point,NC,USA,North America
7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia
2,M,Raza,Cell Phone,2,800,2015-07-15,Charlotte,NC,USA,North America
5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia
4,John,Rivers,Laptop,5,2400,2014-03-09,Jersey City,NJ,USA,North America
8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
1,Aamir,Shahzad,TV,1,700,2015-07-15,Charlotte,NC,USA,North America
12,aamir,Shahzad,TV,1,7000,2015-07-15,Charlotte,NC,USA,North America
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
//how to use running total in Kusto
TotalSale
| order by SoldDate asc
| serialize RunningTotal=row_cumsum(ItemsSold)
| project id,SalePersonFName,SalePersonLName,ItemsSold,SoldPrice,RunningTotal
//Running total by Region
TotalSale
| order by Region,ItemsSold
| project id,SalePersonFName,SalePersonLName,ItemsSold,SoldPrice,SoldDate,Region,RunningTotal=row_cumsum(ItemsSold, Region != prev(Region))
For Education,jobs, news, health, Business, Astrology
ReplyDeletehttp://wisdommaterials.com/
https://www.globalcompaniesinfo.com/
http://wisdomallcodes.com
Students seek thesis writing assistance primarily due to time constraints. Many of them also have problems with research, writing attention-getting claims, defending a large issue, and formatting. Don't hesitate to contact us for the greatest thesis help available online if this describes you. We'll provide you with a custom-written, low-cost, well-researched, plagiarism-free paper that will impress both you and your professors.
ReplyDeleteSurprise I was unable Find Mobile Tire Repair Near You
ReplyDeleteto withdraw,i tried reaching the website
administrator,i was then asked to invest more money
ReplyDeleteIt is an impressive source of getting useful information. I appreciate you after surfing through your article. Once more thanks for sharing. unimed cut off mark for bio-technology