Hi guys - I've attached a sample Excel file i'm using, to try and show how many client's exams were requested on a date which is equal to today. So, in this example, based on today's date of 20/11/2019, I would like it to count all those instances where:
AD_Data is equal to 'Demand' only
AD_Request_Date is equal to today's data - so for today it would be 20/11/2019
Also, would like to show the average count of instances over the past 5 days using AD_Request_Date as the date reference.
We count using AD_Event_Key as this is a unique / distinct counting reference.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.