With the newest Universal Reporting, the need to include external data quickly came into the picture for me. But at the moment, dashboards only show data from actual projects. So I found a workaround
The goal of this example is to have a dashboard with sales (from Asana data) as well as Pipedrive lead number and weighted volume. Here’s the final result:
The third graph is just a bar chart made from a Revenue project that contains invoices. The trick lies within the two other charts: their source is a stand-alone project, created only with the purpose of holding external data:
That might seems a little weird, but that works! This special project could be manually updated by someone on a regular basis, or you can some automation filling in those values that’s what I’ll do myself
Then the chart settings look like this:
Anyone finds this useful? Let me know!
Bonus point from @Jerod_Hillard : tke “Pipedrive KPIs” project could actually be a shared project with various KPIs, and a dropdown with dashboards to filter on kpis to use.