Project Management

Get Involved. Join the Conversation.

Topic

    Durga Prasad Mohapatro
    Project Progress Analysis with Line Graph
    Topic posted December 5, 2018 by Durga Prasad MohapatroSilver Medal: 2,000+ Points 
    35 Views, 2 Comments
    Title:
    Project Progress Analysis with Line Graph
    Summary:
    Project Progress Analysis with Line Graph
    Content:

    I have created an analysis to capture the overall project progress by month and added a line graph. Now, I have achieved this by using Master Child Events. But this is very rough. I need your inputs to make it more streamlined.

    I have two issues:

    1. First I need to choose the project task.

    2. Then I need to click on the task name, which updates the graph.

    My requirement is, To have an analysis with project no and project name prompt only and the table and the graph showing the overall project progress only. 

     

    Image:

    Comment

     

    • Dustin Grabowski

      Have you attempted to create a dashboard with Dashboard Prompts for Project/Task.. Your analysis could then include 'As Prompted' filters which would control both the Table and Graph components.

      • Durga Prasad Mohapatro

        Thanks, Dustin.

        Yes. Dashboard and Dashboard prompts make it easier.

        Now, to the next step, We need only two prompts Project No and Project Name.We dont want to choose task number everytime. When we choose the project No and project name, the table should automatically default and filter for the task number = project number.

        e.g. In the above case, we have to choose the project no, then choose the task number (summary level project task, which is always same as the project number)

        How to do this?