AnsweredAssumed Answered

No way I can make this chart work...

Question asked by avallejo on Jan 8, 2017
Latest reply on Jan 9, 2017 by electon

Ok, now this is officially driving me mad. I've been trying for days to make this work, but I can't figure it out. It shouldn't be that difficult, even for a novice like me. Sure there's something I'm not seeing, so any help would be appreciated.

I have this table below: (it's in Portuguese but that shoudn't be a problem)

tabela.png

I want to chart surgery (3rd column) by surgeon (2nd column). I have sorted the table by surgeon. So I set this up:

count.png

It should count how many records have the field "surgery" not empty, or valid, right? It does not. I tried the same with ID, to the same effect. Sorted as it is, I thought it should do the trick... Setup is Current Found Set and Summarized groups of records

 

Then I try to just reference the field Id (the unique number of the table), but it only shows the first record ID of each surgeon.

 

cir.png

 

FM 15 here. Any light would be very welcome!

 

Best, Andre

Outcomes