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 

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.