Skip to main content
10 answers
  1. Feb 15, 2023, 11:53 PM

    Ah I see. That's because the date pill is using HOUR. That will truncate the minutes and seconds. Try creating this calc:

     

    Hour Numeric

    // Tranlate the hour of the start time to a decimal number.

    // Minutes and seconds will be a portion of an hour.

    DATEPART('hour', [Start Time])+

    DATEPART('minute', [Start Time])/60+

    DATEPART('second', [Start Time])/3600

     

    Then use that on the columns shelf. Make sure the pill is a dimension and that it is continuous.

     

    Ah I see. That's because the date pill is using HOUR. That will truncate the minutes and seconds. Try creating this calc: Hour Numeric// Tranlate the hour of the start time to a decimal number. 

    See attached.

0/9000