Hi JayBH,
This is definitely possible.
Create an indicator source record(pa_cube), with fact table: respective ticket table, and filter: assignment group is London and closed on today
Next, create an indicator(pa_indicators) with name say indicator1, unit as %, Indicator source as the one you created earlier.
You might want to click: visible by all roles under access control tab.
Create a new Breakdown Source record(pa_dimensions)
Create a new Automated Breakdown(pa_breakdowns), say breakdown1, with breakdown source as the one you created in the previous step.
Now indicator1 record you had created, click Manage Breakdown and map this breakdown you created to the assigned to field.
On the jobs related list in the indicator, add a historic job, with relative start say 12 months ago to 1 days ago.
Execute the job.
You may also want to create a daily job, which is same as historic job, except relative start is 1 day ago and active is true.
Finally create a formula indicator.(Click new here: https://xyz.service-now.com/pa_indicators_list.do?sysparm_view=formula&sysparm_userpref.pa_indicator...
In the formula, add a fraction:
Click Browse for an indicator: indicator: indicator1, breakdown:breakdown1, and element John Smith and time series aggregate: By month sum +.
In the formula, Add a division symbol </> after the variable and again browse for an indicator:indicator: indicator1, time series aggregate: By month sum +.
Best
Hasan
