Skip to main content
Question

Charting/ Table help

  • Jun 28, 2023 7:04 PM UTC
  • 0 replies
  • 38 views

Hi All, 

I am currently working on a chart to show how many Rotators a Physician has each month. I have a table that tracks the name of the rotator, 5 separate fields for physicians (rotators are paired with 5 different physicians) (the fields are : physician 1 physician 2, etc), start date, end date, month,and year. Does anyone have any tips on how to chart the number of rotators seen by a physician per month. I have the # of observers as my Y-Axis, however, I cannot track all the physicans on the X-Axis since I have 5 fields for this. The only way I can think to fix this is by getting rid of 4 physician fields, and creating a new rotator entry for each physician; however, that would skew the data of the number of observers. Any help is appreciated. Thank you!

This topic has been closed for replies.