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')
I was blending data and so the results were not showing right. It works fine now.