cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to heatmap a timeseries

ronmacdonald
Organizer

I have timeseries metrics with common meta-data.  The first is the count of "calls", the second is duration of calls.  I'd like to create a heat map with the data to quickly identify distribution of call volume by response time across a full week.  To do this would have x-axis as `day of the week`, y-axis as `range of durations`, and the value the number of calls.

 

I'm thinking something like:

Starting with this: `timeseries { avg=avg(otel.tyk.duration), calls=sum(otel.tyk.calls) } 
...
Finishing with this: `| summarize calls=sum(calls), by:{range(duration), 100ms, day_of_week}`

Unsure of the middle and how to unwind the 2 timeseries metrics to get the day of week range, that would allow me to finish...

0 REPLIES 0

Featured Posts