Hi,
I have the following dataset:
| Date | Claim Number | Processing Status | Injury Type |
| 25-05-2020 | 1 | P | Severe |
| 25-05-2020 | 2 | NP | Minor |
| 01-06-2020 | 3 | P | Severe |
| 08-06-2020 | 4 | NP | Severe |
| 08-06-2020 | 5 | P | Minor |
| 15-06-2020 | 6 | NP | Severe |
| 15-06-2020 | 7 | NP | Severe |
| 15-06-2020 | 8 | NP | Severe |
I want to calculate YTD numbers for:
1. total processed (Count of claims with Processing status as P)
2. % processed (Count of claims with Processing status as P / all claims)*100
3. Total number of severe injuries
I tried many methods like AsOfTable, Using RangeSum and Above combinations etc. All these works but the problem is I need to have a date filter in my dashboard. So when i select a particular date, the data is shown only for that date but i want it to be from the start of the year.
Any idea on how to implement this @sunny_talwar @swuehl or anyone else from the community? Thanks in advance.
