Hello @HothaifahHijazi ,
Do you have the filter criterias linked to your Dr Name in your database?
What's the datasource?
Regards
Datasource is a table for the weekly distribution of clinics in the hospital
as in the attachment :
Ok so it should look like this :
Filter(ExcelFileDataSource, And(drpDay.Selected.Value = Day, drpRoomNo.Selected.Value = RoomNo, drpTiming.Selected.Value = Timing)
Regards,
Dear Fildegandalf,
Do I need to run this formula in Datasource or in item ?
thanks,
Hothaifah
appreciated your responses
kindly, see the attachments :
the formula i used :
Filter(Table1,And(WeekDay = Dropdown1.Selected.Result,RoomNo=Dropdown2.Selected.Result,Timing=Dropdown3.Selected.Result)
no value available after " Selected"
and it display nothing
User | Count |
---|---|
125 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
217 | |
181 | |
140 | |
97 | |
83 |