Topic: How to Use Min and Max Function in Kusto Query
In this article we are going to learn about min and max functions in Kusto Query Language min and max functions are used to find the minimum values and maximum values 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.
// min and minif - Returns the minimum value across the group for which Predicate evaluates to true.
//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
//Get the Max value across table
TotalSale
| summarize min(SoldPrice)
// get max value for each Region
TotalSale
| summarize min(SoldPrice) by Region
//using max by using Region by using maxif
TotalSale
| summarize minif(SoldPrice,Region=="Asia")
TotalSale
| summarize minif(SoldPrice,ItemsSold>3)
A friend of mine recommended brillianthackers800@gmail.com to me although i was feeling skeptical about them at first but i went ahead to message them and they helped me settle bank loans and they also helped me increase my credit score you can chat them on WhatsApp +14106350697
ReplyDeleteThey will surely help you with your hacking problems at a very affordable price and they are very reliable and they deliver a perfect job
This comment has been removed by the author.
ReplyDeleteI couldn’t bear the pain of losing all my money to a fake cryptocurrency platform because I had been taken for a fool who trusted the wrong people. I went to the authorities but there was nothing they could do to get back my money from this cryptocurrency platform until my friend told me about Spyweb Cyber Security Service, after my research about Spyweb Cyber Security, I found them to be the most reliable and trustworthy crypto recovery service out there. I provided all the information of my scam to Spyweb Cyber Security Services and my money was recovered within 72 hours. I’m truly grateful for their top-notch service and Spyweb Cyber Security is indeed the best and most reliable cryptocurrency recovery company. I would suggest you contact them if you wish to recover your cryptocurrency.
ReplyDeleteE-Mail: SPYWEB @ CYBERDUDE. COM
Whats App Contact: +1 323 904 8824
HARNESS THE EFFECIENCY OF CRYPTO RECOVERY-SYNACK TECH
ReplyDeleteI came across SYNACK TECH which is an exceptional and highly reputable private licensed investigation firm based in the states that i had the privilege of engaging with after my company suffered a loss of $950,000 worth of btc due to a mistaken transfer to an unknown account by our financial accountant. Despite our desperate attempts to recover the funds through traditional channels and various recovery firms, we were met with disappointment and further financial losses. However, our fortunes changed when we discovered SYNACK TECH. Upon contacting them, their team of skilled professionals' swiftly and effectively managed to recover $830,300 of our lost funds, bringing immense relief and peace to our company. Their dedication and expertise were truly impressive, and their ability to successfully recover such a significant portion of the lost funds is a testament to their exceptional capabilities in the realm of cryptocurrency recovery. I wholeheartedly recommend SYNACK TECH for any hacking services and crypto recovery needs as their outstanding performance has not only mitigated the financial impact on our company but also restored faith in the possibility of recovering lost assets in the complex world of cryptocurrency. This experience has highlighted the invaluable importance of seeking out a reputable and skilled professionals like SYNACK TECH when faced with similar challenges, as their proficiency and commitment to their clients' success are truly unique and unmatched. With their extensive knowledge and unwavering dedication, SYNACK TECH has proven to be an invaluable asset in navigating the complexities of cryptocurrency recovery, providing hope and a lifeline for those who have experienced significant financial losses in the digital asset space. Their swift and effective actions have not only mitigated the devastating impact of our financial loss but have also restored our confidence in the possibility of recovering lost assets in the intricate world of cryptocurrency. I cannot overstate the level of gratitude and admiration we hold for SYNACK TECH, as they have not only demonstrated unmatched expertise but have also exhibited a deep commitment to their clients’ success. If you in a similar predicament reach out to SYNACKHACK {@} TECH {-} CENTER {DOT} COM