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...