Forum Discussion

TomFarmer24's avatar
TomFarmer24
Frequent Visitor
1 year ago
Solved

Project Tracking Forecast vs Completion Date

Good Afternoon All,   This might be a basic questions, but seeking some advise.    I am looking at creating a simple visualisation that can tell me the number of projects that are on track to mee...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    TomFarmer24 , You can load your data and create a calculated column by going to modelling tab and new column to check status of project

    OnTrack = IF([ForecastCompletionDate] <= [ApprovedCompletionDate], "On Track", "Not On Track")

     

    Go to the "Visualizations" pane and select a chart type, such as a bar chart or pie chart.
    Drag the "OnTrack" column to the "Axis" or "Legend" field well.
    Drag the project name or a count of projects to the "Values" field well.

     

    If you need more details please share sample data and indepth requirement

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

TomFarmer24 , You can load your data and create a calculated column by going to modelling tab and new column to check status of project

OnTrack = IF([ForecastCompletionDate] <= [ApprovedCompletionDate], "On Track", "Not On Track")

 

Go to the "Visualizations" pane and select a chart type, such as a bar chart or pie chart.
Drag the "OnTrack" column to the "Axis" or "Legend" field well.
Drag the project name or a count of projects to the "Values" field well.

 

If you need more details please share sample data and indepth requirement