Forum Discussion

mik618's avatar
mik618
Icon for Helper I rankHelper I
6 years ago
Solved

active at certain times

Hi there,    I've been asked to do various reports looking at improvment and display this in a graph, one report is looking at confirming appointments, every appointment should be confirmed the dat...
Need Help
mik618's avatar
mik618
Icon for Helper I rankHelper I
6 years ago

Hi jdbuchanan71 

 

Thanks for helping, it would be 3 unconfirmed at this date as id 1001 would still be outstanding, thats the problem I'm having it needs to be able to look at all unconfirmed appointments, not just the appointment dates, so we can look at any date in the last year or so and see how many were outstanding at that time. 

 

Thanks 

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

mik618 Is your table only the unconfirmed appointments?  If so you can do a COUNTROWS (YourTable), pull the appointment date into the chart and the measure into the values and see the unconfirmed appointments by date.