Forum Discussion

35532's avatar
Qrew Member
11 months ago

Charting/ Table help

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!

No RepliesBe the first to reply