Forum Discussion

villasenorbritt's avatar
villasenorbritt
Icon for Resolver I rankResolver I
3 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

what's the biggest bin size you can get away with for this?  half hour slots? 15 minute slots? 5 minutes?