![]() ![]() | extend JobReducesSeconds = sum_TotalReducesSeconds * 1 | summarize sum(TotalReducesSeconds) by UnitOfWorkId | filter Timestamp >= datetime( 11:00:00Z) | extend JobMapsSeconds = sum_TotalMapsSeconds * 1 | summarize sum(TotalMapsSeconds) by UnitOfWorkId | summarize count() by duration=bin(min_duration/1s, 10) In this example, because of a preference for a bar chart, divide by 1s to convert the timespans to numbers: // Count the frequency of each duration: #Kusto summarize code#The argument prefixes min_ to each column name.Īdd code to count the durations in conveniently sized bins. If you don't do this step, Kusto automatically uses one-hour bins that match some start times with the wrong stop times.Īrg_min finds the row with the smallest duration in each group, and the * parameter passes through all the other columns.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |