2 Replies Latest reply on Aug 2, 2018 4:10 AM by Jaime Hutchins

    Tableau Volume calculation based on Start Date and End Date

    Jaime Hutchins

      Using Tableau, I need to create a visualisation that shows me the total volume of started and ended work items per day.

      Typical sql data consists of columns for each:

      Reference (Unique Work Item Reference) Start Date (Date Work Item Started) End Date (Date Work Item Finished)

      For example, if on the 6th of April 2018, 55 work items were started and 5 items were finished. Each represented date should show in its own line over time.

      The issue I'm getting at the moment, when I have start date as a continuous column, it calculates the number of work items started for the end date and not the number of items finished for the end date.

      Any help guidance would be greatly appreciated.