What do you have in your database? You'll need something relating to the date to get tickets per week.
I have Originated_Dt for each ticket. But the requirement is given every week , a stacked bar per 3 categories the No. of tickets.
How do I get generic date field in Tableau for this ?
You could create a calculated field using datepart to get the week. Something like this: DATEPART("week", [Your Date Field])
Or, when you drag your date field to the view, you can right click on the pill and change it to display the week number.
Is that what you need or are you looking for the date of the first day of the week?
If you need a specific date, then use DATETRUNC in your calculated field as follows: DATETRUNC("week", [Your Date Field], "Monday")
The final parameter should be the start of your week: Sunday, Monday, etc.
Thanks for the inputs but I am looking something else... Let me try to explain again..
Given a table with columns : Ticket ID, Ticket_Status ( New , Resolving , Closed ) , Originated_Dt , Due_Dt
I need to create a bar graph with
- X axis: the week and year: example ( All weeks - This date field does not exist in my table currently )
- Y axis: numbers of tickets per status: closed, assigned, resolving...
So I will probably need to crate a calculated field which can say given a Week , The no. of tickets...
You won't need a specific calculated field for week/number of tickets. Tableau will do this for you. Take a look at the attached. It uses superstore data, but we can pretend that Order Date is your Originated_Dt and Segment is your Ticket__Status.
Week Number.twbx 1.2 MB