I’m a developer new to using Quicksight hoping to study a bit more in detail about how our APIs are used. I’m looking for some general guidance in order to visualize chains of calls being performed to our APIs to see if there’s room for performance improvements across our architecture.
For example, I have records with the time a request was made and a response was sent, so I’m looking for some way to see a call that was made (based on request_creation_time) right after the response time of another record, and then gather trends on that.
Thanks for posting your question and welcome to the QuickSight community.
Within your dataset, are there keys upon which you can associate one row to another? For example, below, I’ve taken your example data, re-ordered and added columns for request ID (rid) and next ID (next_rid).
rid
request_creation_time
time
next_rid
1
2024-06-30 23:59:42
2024-06-30 23:59:44
4
2
2024-06-30 23:59:43
2024-06-30 23:59:45
5
3
2024-06-30 23:59:43
2024-06-30 23:59:53
4
2024-06-30 23:59:58
2024-06-30 23:59:59
5
2024-06-30 23:59:59
2024-07-01 00:00:01
6
6
2024-07-01 00:00:02
2024-07-01 00:00:04
If you also calculate the duration of a request then you could plot these associations and visualise the duration of each request using a Sankey diagram as follows:
Hi @lmedina, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
