4 Replies Latest reply on Dec 5, 2018 11:44 AM by Vladimir Khvan

    Graph count of items active month over month

    Jason Ludwig

      I am attempting to do something very SIMPLE that Tableau makes very DIFFICULT:

       

      I need to display a bar chart, columns by date (month), that shows the number of tasks that were "active" during that month.

       

      An active task is one that began/ended within the month/column, or one that began before the month started and ended after it ended.

       

      I was hoping to be able to do something as simple as making a calculated field as such:

      IF [Opened]<"MAX IN COLUMN" AND [End Date]>"MIN IN COLUMN" THEN TRUE ELSE FALSE END

       

      I tried:

      IF [Opened]<MAX([Date]) AND [Closed]>MIN([Date]) THEN TRUE ELSE FALSE END

       

      But, as you may have guessed, this causes a mixed aggregate/non-aggregate calculation error.

       

      How can I go about getting the tasks (rows) that were active during that month?

       

      Essentially, a task that began in march and ended in july should be counted in the column for mar, apr, may, jun and jul.