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.