5 Replies Latest reply on Aug 30, 2013 11:56 AM by Patricia Santillan

    Create a variable where mon - Fri = Weekday, Sat and Sun separate

    Patricia Santillan

      I work for a bus company and the same route will have a different schedule for M-F, one for Sat and one for Sun.  In excel I can use a formula to first tell me the day number (1-7) and then I can use an if statement to say if the day of this date is a 7(Saturday), show me "SAT, if a 1(Sunday), show me "SUN" else show me "Weekday".  How do I do this in Tableau?  I need to group ridership totals by this variable and I can't figure out how it can work.  Thanks in advance!