Stack Overflow
Stack Overflow

Questions tagged [kusto-explorer]

Questions relating to Kusto.Explorer and using the Kusto Query Language with it.

256 questions
10
votes
3 answers

How do I print a tree using the Kusto Query Language?

Below is a quick and unglamorous solution. If you have a better one, please include it in your answer. let tree_height = 15; range i from -1 to tree_height * 2 step 2 | extend side_width = tree_height + 1 - i / 2 | extend side_space = strrep(" ",…
Yoni L.
  • 22,627
  • 2
  • 29
  • 48
7
votes
1 answer

Get top 1 row of each group using Kusto

I have a table which I would like to get the latest entry for each group using Kusto Query Language. Here's the…
cmomah
  • 165
  • 2
  • 9
5
votes
1 answer

Views vs Materialize Vs Materialized View in Kusto

Scenario: Data in kusto table is updated after 5 hours. Task: Call query from .net API In query , create a subquery and use that subquery to perform join on a bigger table let table1=materialize( Customer|where…
jaime_
  • 71
  • 1
  • 7
5
votes
2 answers

Kusto - Remove additional text from variable (Legend) in Kusto chart

I have a Kusto chart that has Legend with the Variable name (Platform) from the Query. I would like to remove the additional text from this Legend. I did some research and was able to see similar results from SQL but could you please tell me how do…
Jeganaak
  • 313
  • 1
  • 3
  • 23
4
votes
2 answers

How to detect if Tabular variable is empty in KQL

I have a dashboard populated with a number of Kusto KQL Queries. Sometimes, my query below returns zero results (for instance if by miracle, there are no failures in the last 24 hours). //my dashboard query let failureResults = exceptions | where…
FoxDeploy
  • 12,569
  • 2
  • 33
  • 48
3
votes
0 answers

Using Azure Resource Graph from Kusto

Is there a way to access Azure Resource Graph data from Kusto.Explorer? How would I configure the Connection in Kusto.Explorer?
Felix Bodmer
  • 291
  • 2
  • 16
3
votes
1 answer

Kusto - Join two tables and count keys from first table and second table on every record from first table

Need to Join two tables and count key from first table and second table on every record from first table let T = datatable(TId:int, TName:string, Tkey:string) [ 1, "A", "xyz", 2, "B", "xyz", 3, "C", "yza", ]; let u = datatable(UId:int,…
Sahil Raj
  • 107
  • 9
3
votes
1 answer

Kusto, retrieving all the rows with maximum values

I want to create a MV based on a query like this ("data" is my table): let data = datatable(Fruit: string, Color: string, Version: int) [ "Apple", "Red", 1, "Apple", "Green", 1, "Pear", "Brown", 1, "Pear", "Green", 2, ]; let data2 = data| summarize…
Rachel Bushrian
  • 31
  • 1
3
votes
1 answer

How can we fill a column with specific values in Kusto?

I have a table in kusto with 13,000 rows. I would like to know how can I create a new column in this table which fill it with only 2 values (0 and 1) randomly. Is there also a possibility to create a column containing 3 different value of data type:…
Noobie2021
  • 281
  • 4
  • 23
3
votes
2 answers

Get Other columns based on max of one column in Kusto

I am trying to write a Kusto query to find record who has max value in column grouped by another column but also requires 3rd(remaining) columns with it. Let there be three columns A(timestamp) B(impvalue: number) and C (anothervalue:string). I…
Allen Harris
  • 53
  • 5
3
votes
1 answer

When a variable is in scope, it still does not refer to any known column, table, variable, or function

The following query succeeds when we select all (CTRL + A) run (F5) it. let Foo = "foo"; let Bar = (baz: string) { print baz; }; Bar(Foo); // errors here The problem is that the Kusto Explorer lists two issues. Both Foo and Bar are unknown.…
Shaun Luttin
  • 133,272
  • 81
  • 405
  • 467
2
votes
1 answer

Kusto Go API query from multiple tables

I'm using Kusto API to query logs from 2 tables, however they are in 2 different databases which are in different clusters and therefore have different endpoints (I can't modify the clusters). I would like to know if it's possible to use Kusto API…
koonig
  • 67
  • 4
2
votes
1 answer

Compare data between current value and previous value - Kusto

I want to find the id value of rows whose humidity is greater than the previous day humidity. datatable(id:int, recorddate:datetime, humidity:real) [ 1, datetime(2022-11-01), 10.0, 2, datetime(2022-11-02), 12.0, 3,…
Arunbi
  • 23
  • 3
2
votes
3 answers

Kusto command to see all column names in table?

I don't find .show table details helpful, I would just like to see the name of every column in a kusto table
Shisui
  • 1,051
  • 1
  • 8
  • 23
2
votes
1 answer

Kusto summarize total count from different rows

The count from the below data table for the same build, device, and Tier is split into different rows because the os versions are different. How do I summarize the total, excluding the platform os, please? For example , I need to summarize the total…
Jeganaak
  • 313
  • 1
  • 3
  • 23
1
2 3
…
16 17