1 Reply Latest reply on Oct 18, 2018 7:50 AM by seraj alam

    Filter to latest week if we use calculated column as a filter

    Varma Rajakakarlapudi

      Hello Everyone , I created a calculated column "Week Part " which will show the week number of the month . I used it in the filter so that the data can be filtered by weeks. As it is a calculated column, I am not able to do filter to latest data .My report is getting refreshed every week .Whenever it is getting refreshed , the report is not pointing to the latest data(new data that got refreshed) . How can I resolve this issue , so that whenever the report is refreshed , I can see that the report is pointed out to the latest data.

       

      This is the formula I used to calculate week number .

       

      DATEPART('week',[Created Dtm]) - DATEPART('week',DATETRUNC('month',[Created Dtm]))+1