2 Replies Latest reply on Oct 23, 2018 5:04 AM by Subhashini Gadesina

    Relative date: for 24 hours Data from 10/23/2018 to 10/23/2018 using Parameters with only date

    Subhashini Gadesina

      Customer wants last 24 hours analysis such that start time = 10/23/2018 and end time = 10/23/2018.

      First Method: Here I have created Start date  and end date parameter with only date format not with date and time format. If i select 10/23/2018 to 10/23/2018 by default tableau giving the start date is 10/23/2018 12:00:00 AM and End Date 10/23/2018 12:00:00 AM only. Here I need all transactions which were happened during the entire day.

      Second Method: Here I have created Start date  and end date parameter with date and time format like (Start date: 10/23/2018 12:00:00 AM and End Date: 10/23/2018 11:59:59 PM). If I try to change end date only date not time even time also changing to default like 10/23/2018 12:00:00 AM. can we can't fix time like for start date means 12:00:00 AM and End Date Means 11:59:59 PM. Here just we need to change a date not time.

       

      need help on this.