2 Replies Latest reply on Jul 6, 2016 4:39 AM by Adam Wrona

    Changing starting day for week issue

    Adam Wrona

      Hi,

       

      I am trying to create some weekly summaries based on week starting on Friday. I want to set up sum WINDOW_SUM functions using number of weekday. However when I use DATEPART function it is not changing and always showing Sunday s day 1.

      I use following function: DATEPART('weekday',[date],'friday'). I have also tried chaning Date Properties for the data source to start week on Friday but still nothing.

      Date that is downstreaming in the SQL I am using is date + time, I have change format in Tableau to show only date.

      Do you have any ideas what might be causing this?

      My version of Tableau is 9.1.2, 64-bit.

       

       

      Adam