Forum Discussion

AgeOfEgos's avatar
AgeOfEgos
Icon for Helper I rankHelper I
7 years ago

Tracking time over a date range--insists on doing count

I have a custom column that computes the duration/datediff of two separate dates.  It's working fine and when I put this into a standard data grid, it appears appropriately (see below).   However, ...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi AgeOfEgos 

As tested, it shows correctly in this case.

If your problem still occurs, please show some screenshots with me for better analysis.

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AgeOfEgos's avatar
    AgeOfEgos
    Icon for Helper I rankHelper I
    7 years ago

     

    I can't remove the count, it only gives me options of max/min/etc. even though the custom column is not summarized.

     

    The custom column is figured by this formula;

     

    Time Tracking = DATEDIFF(Sheet1[Report Final],Sheet1[Exam Complete],MINUTE) * -1

    Thanks.

     

     

     

     

     

    • v-juanli-msft's avatar
      v-juanli-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi AgeOfEgos 

      AgeOfEgos wrote:

      I can't remove the count, it only gives me options of max/min/etc. even though the custom column is not summarized.

      When you add a column in the "value" field of a line chart, it will be summarized by default.

      You could create a measure as well

      Measure Time Tracking = DATEDIFF(MAX(Sheet8[Report Final]),MAX(Sheet8[Exam Complete]),MINUTE) * -1

      Since there are mutiple line data for a single datetime point of [Exam Complete], the Time Tracking should be sum for each datetime point of [Exam Complete].

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • AgeOfEgos's avatar
        AgeOfEgos
        Icon for Helper I rankHelper I
        7 years ago

        Thanks for the help.

         

        When I plug that formula in--I am only getting one result per date instead of multiple.  I think it has something to do with my date column.  See photos attached.