1 Reply Latest reply on Jun 7, 2017 12:10 PM by vasudha.sripuram.0

    Count as Dimension

    vasudha.sripuram.0

      Hi All,

       

      I am new to Tableau and I am puling data from a query which displays as below in the database.

      Here TICKETCOUNT is a dimension and when I try to place it in dimension or add as a measure like AVG(TICKETCOUNT) it does not give me the right result?

      How do I make Tableau to display the exact value for each day?

       

      select jobid,trunc(create_time)create_time,RESULT_FIELD_1 team,RESULT_FIELD_2 status,


      RESULT_FIELD_3)ticketcount from  table1 a where jobid in ('J11')


      record_type='DT'


      result_field_1 in ('ISC')

       

       

       

       

      Thanks!!