1 Reply Latest reply on Mar 18, 2012 4:19 PM by Alex Kerin

    Calculation - Urgent

    shilpa g
      # of Release Management Tickets
      JanFebMarAprMayJunJulAug
      Open5052
      Closed4854
      % Adherence98%99%

       

      Hi,

      I have a column which contains, ticketstatus. Open, Closed, Accepted, In pgress, Resolved etc. I am filtering only open and closed tickets as per requirement.

       

      I have Month(open_time) on my column shelf and countr(number_of_tickets) on rwo shelf.

       

      1. I need open and closed as side by side bars , not the stacked bars. (  have placed tcikets_status col on color shelf)

      2. I need to calculate % adherence . Means , Count(closed_tickets)/count(open_tickets)*100.

       

      Please let me know how to achieve this as i m new to tableau and trying to figure out.

       

      Kindly respond.

       

      Thnks in advance.