Forum Discussion
Solved
Excluding Time Frames in Visual when Populating Values with a Measure and Rows with Time Bins
I have a measure that is taking seconds, which corresponds with downtime for a specific machine, and turns it into a duration. Here is the measure : Chelsie Eiden's Duration = // Duration format...
Phew. Create a calendar table that goes down to that level (ie 48 rows per day) and then based your measures on that new calendar table, using EXCEPT and INTERSECT.
what's the biggest bin size you can get away with for this? half hour slots? 15 minute slots? 5 minutes?
Half hour slots is the biggest bin size I can get away with for this.
Phew. Create a calendar table that goes down to that level (ie 48 rows per day) and then based your measures on that new calendar table, using EXCEPT and INTERSECT.
