Hello!
I’m currently attempting to use data pulled from Azure Monitor to create a stacked bar chart for my dashboard. It’s pulling the responses to requests made to an endpoint, which will have either 200 or 500 status codes. In my query, I’ve summarized the data to hourly timestamps with the status code and the count for that status code.
timestamp | statusCode | count
--------------------+-----------------+--------
2024-11-25 09:00:00 | 200 | 11
2024-11-25 08:00:00 | 500 | 19
2024-11-25 08:00:00 | 200 | 17
2024-11-25 07:00:00 | 200 | 3
2024-11-25 06:00:00 | 200 | 6
2024-11-25 05:00:00 | 200 | 9
2024-11-25 04:00:00 | 200 | 13
2024-11-25 03:00:00 | 200 | 14
2024-11-25 02:00:00 | 500 | 30
2024-11-25 02:00:00 | 200 | 36
Ideally I’d like to have a bar for each timestamp such that it’s a stacked bar made up of the counts of both 200 and 500 responses for that timestamp, with the 200 responses having a green bar and the 500 having a red bar.
In my current attempt however, all I’ve managed to do is get the bars for each timestamp as desired, however it will not stack the ones from the same timestamp, so there’s two separate bars for any timestamp with both 200 and 500 responses. I’ve been unable to get the bars to be colored accordingly as well.