3 Replies Latest reply on Nov 21, 2018 9:03 AM by Divya Chhabra

    How can I group certain values and create a graph of their trends over time?

    Divya Chhabra

      Hi,

       

      I have blood sugar levels that I would like to group as "below 5", "5.1-7.9" or "above 8" and then create a line graph over time that shows the those levels changing over time.

       

      I can't share the workbook because it contain patient information, but here are my columns:

       

      Patient ID

      Patient Name

      Lab Date

      Lab Value

       

      So, I would like to see a lab value of 4.6 and group it as "below 5," then see a lab value of 7.3 and group it as "5.1-7.9" etc and use Lab Date to plot these values per month as a percent of total lab values in that month.

       

      I've tried to use sets with a condition of "Lab Value <=5.0" but it's counting all Lab Values as below 5.0, even if the value is above 5.0.

       

      Any help is much appreciated!

       

      Thanks,

      Divya