Forum Discussion
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, when I attempt to do a line graph showing the time over a date axis--it insists on doing count. If I try max, it appears it sums it over the date range--and gets larger. How can I do a date axis with the duration for each date?
4 Replies
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
MaggieCommunity 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.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.
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
MaggieCommunity 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.
