I have some troubles trying to automate some dashboard.
Basically I have a table with all the worklogs of my company (about 5000 lines per year).
What I want is create dashboards for each project of the company.
In this dashboard I wanted to have the view of the total time spent on a project, but also have a diagram on how much time has been spent per month.
What I thought was that the best would be to have another table that I could fill automatically with the calculatedd values. But maybe that’s not the correct way ?
If you have any idea I would love to have your insight !
Thanks a lot.