I have created and attached a worksheet to understand the work volumes of Incidents and Service request created.

Actual value, will be the actual numbers(distinct count of tickets for every Request Category) from the days selected in the filter(NO avg,NO sum, just the distinct count)

Plan value, will be calculated based on the the number of days selected in the filter. For example, if [Select View:Daily] 7 days is selected, then actual no of tickets for 7 days will be counted and plan will be avg per day for the last 6 months * 7 will be calculated.

Basically multiplied by whatever is selected in the filter.

Another example will be, if [Select View:Weekly] 3 is selected, then actual will be the count of tickets for 3 weeks and plan will be avg per week for the last 6 months * 3.

To achieve this dashboard I have derived the below formulas, but i am not confident enough about the Plan value and variance it shows on the dashboard.

Are you seeking assistance with this request still? This was a few weeks back and you were looking for verification of numbers. I suggest utilizing a crosstab view to verify numbers and walk through the calculations and expected values for a few of your data marks.