CODEWITHSUNDEEP
azure-data-explorerkqlkusto-explorer
Milo_Dev
Milo_Dev

Reputation: 425

Kusto - Conver table data to time series chart

I have a Kusto table result with different package sizes released for 2 types of VM´s on daily basis. On the table I have the 3 columns - 1) Timestamp, 2) VM Type (Win & Linux split), 3) Package size in MB.

Could you please tell me how do I create a graph that will have Y axis as timestamp, x axis as Package size and with the line representing the package size for VM (Win & Linux) Basically it will appear as 2 lines on the graph showing the package sizes for diff days.

I tried with visual type - line chart option but it does not work with any combination of X and Y axis in Data column. I am not sure if the render time chart will work . Could you pls provide any suggestion. Thanks

Upvotes: 1

Views: 1973

Answers (1)

Yoni L.
Yoni L.

Reputation: 25955

If I understood your description correctly, you could try something like this, assuming Timestamp is a datetime column:

TableName
| summarize take_any(PackageSize) by VmType, bin(Timestamp, 1d)
| render timechart

Upvotes: 1

Related Questions