Hi,
I have a SQL table with Column Names Date,Program,Cases
| PROGRAM | date | CASES |
| A | 4-Sept-19 | 3 |
| A | 7-Sept-19 | 1 |
| A | 8-Sept-19 | 1 |
| A | 9-Sept-19 | 2 |
| C | 1-Sept-19 | 2 |
| C | 7-Sept-19 | 1 |
| B | 4-Sept-19 | 1 |
| B | 10-Sept-19 | 1 |
| D | 5-Sept-19 | 1 |
| D | 6-Sept-19 | 1 |
| D | 12-Sept-19 | 1 |
| E | 15-Sept-19 | 1 |
| E | 18-Sept-19 | 1 |
This table is updated daily.
I have Yearly targets for each Program. Also if required I can calculate the business working days for each month. Even Monthly
Next what I want to implement in my dashboard is using the Yearly Targets and the business working days, how can I calculate the Daily or Weekly Targets or Monthly(Currently I have monthly calculated manually and feeding it) for each Program?
I am not asking for a code but a procedure how to go about it would be helpful
Thanks
