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

    Count as Dimension


      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')


      result_field_1 in ('ISC')