i was curious to see if the reporting function could overlay data from multiple databases. my use case is to get a report that forecasts income over time. This would include net project income, generated from my Project db plus projected sales, something generated from my Sales db (with the ability to see the two separately) and lastly a horizontal dynamic annotation showing our staff capacity, generated from my Employee db. something like my crude sketch below. any thoughts on if something like this is possible
Something close to what you’ve drawn may be possible
One potential issue is that the report view charts only support a single y axis scale, so the values from several dbs may need normalising.
I suggest pinging us in the chat and we can help you with figuring out the best solution.