Create report from two different datasets

Hey there,

I’d like to bring up an old topic and ask if it can be addressed. The original post is from 2020 (!).
https://support.zendesk.com/hc/en-us/community/posts/4409222532506-Create-report-from-two-different-datasets
 

I recently asked the same question in the chat and received this response:
 

If the information we need is only available in specific records (like update history, backlog, or tickets), it can't currently be combined into a single report or chart in Zendesk Explore.
 

So, my question, which obviously many other Zendesk users also have, is:
 

How can we create a report that shows all relevant data in one chart or graph?
 

For example:
 

- Created tickets (from the tickets record)
- Open tickets (this includes unresolved tickets in the backlog and pending tickets)
- New requests (from the ‘Requests’ dataset)
- Resolved tickets (from the ‘History’ dataset)

Like this one created from random data using Google Sheets:
 

Cheers
Will