Working with particular dates/date range in Zendesk reports calculated metrics (Formulas)
1. This Week Tickets (Created)- Count of tickets created between Friday of the previous week and Thursday of the current week.IF (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days")<=7) THEN [Ticket ID] ENDIF
2. Last Week Tickets (Created)-Count of tickets created between two Fridays ago and Thursday of last week.IF (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days")>7) AND (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days")<=14) THEN [Ticket ID] ENDIF
3. Last 4 Week Tickets (Cretated)-Count of tickets created between four Fridays ago and Thursday of the current week.IF (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days")>7) AND (DATE_DIFF(TODAY(),[Ticket created - Date],"nb_of_days")<=35) THEN [Ticket ID] ENDIF
Above are the three metrics I am using to compare Inflow tickets volume of this week(Friday -Thursday) with last week and last 4 weeks volume average.However while doing analysis