1 2 Previous Next 27 Replies Latest reply on Nov 21, 2016 5:52 AM by Tom W

    Help needed with difficult calculated fields

    johann taljaard

      votefavorite

       

       

      I need some assistance to create a calculated field in Tableau.

      I’d like to understand max, min, average time & standard deviation (in mins) that support tickets remain in each Status, broken down by eventual Resolver Group.

      I can retrieve the following from the database.

      TicketNumber

      ResolverGroup

      Updated Date (Updated date does not necessarily change the status)

      TicketStatus

      Statusses available are:

      AWAITING TRIAGE

      IN PROGRESS

      RESOLVED

      TRIAGE AWAITING CUSTOMER FEEDBACK

      ACCEPTED

      ASSIGNED

      ON HOLD

      Then I have to create a horizontal stacked barchart with mins on X column and Resolver groups down Y axis.

      Any suggestions?

        1 2 Previous Next