1 2 Previous Next 18 Replies Latest reply on Oct 4, 2016 11:34 AM by David Li

    How to calculate weekdays dynamically and sum of those days of current week as well as last week

    Anandh V

       

      I want to compare the total sales of Sunday,Monday,Tuesday,Wednesday of last week with Sunday,Monday,Tuesday,Wednesday of current week.

      i want to display the last week first 4 days total sum value and as well as current week 4 days total sum value. the values should change based on the date changes.

       

      Ex: if am in thursday of current week means i need have a total of all the completed days wednesday,tuesday,monday,sunday of current week and relevant days in the last week also.

       

      whenever the date changes accordingly i need to display the total sales dynamically in Tableau.

       

      Let me know any questions.

       

       

      Please help me to achieve this.@

       

      Thanks & Regards,

      Seenu

        1 2 Previous Next