I need to create a single table in Insight Builder that shows:
- All active projects (from admin-projects dataset)
- Their schedule update dates (from schedules dataset)
- Including projects with no schedules (left join)
Problem: Each visual only allows one dataset. I can't blend/join datasets within a single visual.
Solution: Create a way to join two datasets so I can show all projects even if they don't have schedule data?
Thanks!