7 Replies Latest reply on Jul 22, 2013 6:48 AM by Jean-Francois Renaud

    Dashboard to track progress of actions

    Jean-Francois Renaud

      Hi, I have an excel spreadsheet that contains action items with different date to track progress.  We have a start date when the action is assigned, a due date and a closed date.  Based on those dates, I can calculate a STATUS as of today (on target, late, closed).  I would like to build a dashboard to make it easier to depict the overall pictures and see on which action I need to work first.

       

      I also want to look at the overall progress through time and see how many action were started, late, closed at each time since we start.

       

      So with a simple database (attached), do I need to reformat it in a certain way before being able to use it within Tableau.

       

      I'm also attaching a drawing of what I would like to build within Tableau.  Any suggestion?

       

       

      dashboard.png

       

      Thanks!

      JF