3 Replies Latest reply on Aug 14, 2018 3:35 AM by Rajhesh Kumar A S A

# Classifying Ticket Flow on Weekdays and Weekends

Hi Experts,

Need your support. I have attached a sample data where 3 different teams are assigning tickets to Ground Support team. I need to see how many tickets are assigned by these 3 teams to Ground support team during weekdays and Weekends on monthly basis. Attached the input data. I'm using Tableau 10.4. kindly give me the Twbx according to this version or pls give the snaps / calculation formula for the same.

Required Output format

 Team Weekdays JAN FEB MAR APR MAY 1st Level team 10 15 16 18 19 2nd Level team 11 7 6 10 12 Technical Support Team 17 16 8 12 16

 Team Weekends JAN FEB MAR APR MAY 1st Level team 2 8 10 6 3 2nd Level team 3 9 11 7 4 Technical Support Team 4 10 12 8 5

Thanks.

• ###### 1. Re: Classifying Ticket Flow on Weekdays and Weekends

Hi Rajhesh,

You can count weekday and weekends using below logic:

1. day name = DATENAME('weekday',[Assign Date])

2.  count weekday = if [day name]<>'Sunday' or [day name]<>'Saturday' then [Number of Records] END

3. count weekend = if [day name]='Sunday' AND [day name]='Saturday' then [Number of Records] END

• ###### 2. Re: Classifying Ticket Flow on Weekdays and Weekends

Hi Rajhesh,

Create a calculated field like below and arrange the pills as like below

Hope this helps kindly mark this answer as correct or helpful so that it will help others

P.S: Attached workbook connect to the excel which you attached so that you can able to see the calculations @workbook level

• ###### 3. Re: Classifying Ticket Flow on Weekdays and Weekends

Thanks Naveen and Meena.