3 Replies Latest reply on Mar 7, 2018 8:27 PM by Eric Hammond

    Fitbit HR Data - count/avg. min/day over 100

    Riley Mashburn

      This is just a fun project I'm playing with outside of work, but it's brought up an interesting calculation I'm not sure how to approach.

       

      I have minute-by-minute heart rate data for several days. I want to create a dashboard to look at stats for a given day/week. There's two calculations I'm trying to figure out how to approach:

      1. How many minutes of x day recorded a heart rate >=100?
      2. On average, how many minutes per day was HR >=100?

       

      I attached an excel spreadsheet with dummy data for 2 days that is structured the same as my data.

       

      Kudos and cookies to whoever can help!
      (Cookies would have to virtual unless I get a chance to meet you at a conference. )