There is the system where our customers ask questions. And we have to answer them during 4 working days. After we answer, customer closes the question if the answer has satisfied him. If customer does not close the question after we answered, question closes automatically in 3 days after Control Date is come.
The table contains al these information:
Question ID
Control Status (Control Date not come yet, Expired, Closed at Time)
Created Date
Control Date (create date + 4 working days)
Answered Date
Closed Date
So we have KPI, that calculated:
Quantity of closed questions answered until Control Date / (Quantity of closed questions + Quantity of opened and expired questions)
For example,
I want to calculate KPI for 1Q'19. So it means that:
1. Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 and [Closed date] <= 31.03.19 and [Control status] = 'Closed at Time'
2. Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 and [Closed date] <= 31.03.19
3. Quantity of questions [Created Date] <= 31.03.19 and [Closed date] >= 01.01.2019 or [Closed date] = Null() and [Control status] = 'Expired'
KPI = 1/(2+3)
How can i create such calendar, where i can choose YEAR, QUATER, MONTH,DATE?
