3 Replies Latest reply on Jun 4, 2017 10:24 AM by Okechukwu Ossai

    Calculating number of orders in the previous week for a selected current datetime

    Kalluri Siva Reddy

      Hello Team !

      I have the scenario as follows :

       

      1). The user can select a date from the DateParameter (DateTime data type). Lets say user chose 05/31/2017 at 9:00 PM. User wants to count the number of orders (data source attached ) from 05/31/2017 12:00 AM to 05/31/2017 1:00 PM (because this is the latest available datatime in the data source ).

      2) Similarly , user wants to count the number of orders in the previous week for the same day and same time stamp. i.e from 05/24/2017 12:00 AM to 05/24/2017 1:00 PM

       

      Appreciate any help on this. Thanks in advance !!!

      Attached the sample data source and twbx.

      Tableau version : 10.1.1

       

       

      Regards,

      Kalluri Siva