Hi,
This is a simplified view of my database:
Customers
- id
- customerName
- fistName
- ownerId
Projects
- id
- projectName
- ownerId
Owners
- id
- firstName
I'm trying to create 1 dashboard with 2 views: one with info about all customers and one with info about all projects. For this I've created two datasources:
1. Customers LEFT JOIN owners
2. Projects LEFT JOIN owners
I would like to display 1 dashboard with both the customers and projects information of 1 specific owner. I'm able to do this (based on firstName column), however then I lose my ability to display empty columns in both views. And I need them.
What are my possibilities?
Not really.
I would like to add a filter to this dashboard so I can see the number of projects per week and number of customers for 1 specific user, without losing the empty weeks in the "projects over time" dataset:
