1 Reply Latest reply on Mar 5, 2014 5:26 AM by Matt Lutton

    Open Cases Chart

    Tina Starkie

      Hi All,

       

      I'm trying to create a bar chart in Tableau which shows how many contact centre cases are still open on a week-by-week basis, I can easily get the chart to show how many cases were OPENED on a week-by-week basis, but not the accumulative how many are actually still OPEN over each week if that makes sense?


      I have many fields available, but think that the following field options are the ones I'll need to use:

       

      CALLID

      STATUS

      FIRST OPEN DATE

      CLOSURE DATE

       

      Any help would be really appreciated.

       

      Thanks.