Within a demand ticket, a project is created, and subsequently, project tasks are established. Our goal is to develop a dashboard that comprehensively illustrates the timelines of both the project and its tasks, alongside their progression status in a single chart or table.
In demand Table we have demand number
under the demand no we have project created
and under the project the realated project task has created
how do i map the requirement
We need a dashboard that displays:
- The number of demand tickets
- The projects created under each demand
- The project tasks created under those projects
Please guide
Project is maintained in pm_project table and Project task is maintained in pm_project_task table.
You have a common reference project number in both these tables and can use global filters to follow the field option. Create a single or multi-select global filter to display list of projects and place data visualization components to follow the filter for project tasks.
Similarly, you can map the relationship between demand and project tables as they have a relationship between these 2 tables.
Check if progression status is maintained out of box, if not create a metric_definition for the project tasks to track the duration in each state and group by that field.
If this does not work, look at option of creating database view table between demand, project and project tasks if number of records would not exceed more than 10,000 and use it in dashboard. This way you can create global filter on view table and show demand, project and project tasks easily along with metric definition to show duration in each task state.
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
