Forum Discussion
Weekend and Weekday Analysis
Hi, Im trying to create a column which will show me which tickets fall on Weekend and which tickets fall on Weekday. So basically, the goal is identify what is volume of Incident tickets we g...
Hi Anonymous ,
If you want the return value to be in text format, please select the text format first, and then change the calculated column to
Work Day = if(WEEKDAY([Date],2)>=6,"Weekend","Weekday")Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , This flag in date table can give you workday or weekend
Work Day = if(WEEKDAY([Date],2)>=6,0,1)
You can compare Average per day