TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Dashboard Chart for Multiple Data Tables
It would be useful if dashboards could be used to connect data from multiple tables. Particularly as it relates to chart views, though I can see this being useful for other views as well.

For example, if we have a data table for 2024 projects and a data table for 2025 projects, I would like to be able to show the total revenue by month for each year side-by-side within one chart. Currently we have a chart view of revenue by month for each of these project data tables separately, but no way to combine them or show them within one chart on a dashboard.

ID
2105
Category
TeamDesk
Author

Kristy Hayden
Date Created
5/1/2025 1:52:17 PM
Date Updated
5/1/2025 2:07:35 PM
Status
New Idea
Score
10
Promoted By
Kristy Hayden
Comments
Slava Shinderov  Staff  5/1/2025 2:07:35 PM
@Kristy, it may be a case where you should organize your data accordingly.
If you have different project tables for each year, it might be a good idea to merge them into one project table and simply add a Year column.
After that, you’ll be able to create different views to display records for each year if needed, and also create consolidated/grouped reports across multiple years.
Please review the following article for details:
https://www.teamdesk.net/blog/tips-tricks/multiple-spreadsheets-one-table/
Feedback
 
Back to Search Results