Resolve "Queries which return multiple series are not working correctly"

What does this MR do?

Corrects an issue whereby queries which return multiple series results were not rendering as multiple data series on the metrics dashboard

before	after

What are the relevant issue numbers?

• Closes #59324 (closed)
• Closes #59323 (closed)

Does this MR meet the acceptance criteria?

• Changelog entry added, if necessary
• Documentation created/updated via this MR
• Documentation reviewed by technical writer or follow-up review issue created
• Tests added for this feature/bug
• Tested in all supported browsers
• Conforms to the code review guidelines
• Conforms to the merge request performance guidelines
• Conforms to the style guides
• Conforms to the database guides
• Link to e2e tests MR added if this MR has Requires e2e tests label. See the Test Planning Process.
• Security reports checked/validated by reviewer