How to create an indicator which shows total % of tasks assigned to each Assignment Group Quarterly?

[RiteshSwarnakar]

Hello Experts,

I am working to create a indicator in Platform Analytics and one of the requirement is to show the Quarterly % of tasks assigned to each assignment group from overall tasks and it should also follow filter on the dashboard.

Consider total tasks are 100 and only three Assignment groups as below:

EUC Group: Q1 was 59% and Q2 was 42%

Windows Support Group: Q1 was 21% and Q2 was 26%

Linux Support Group: Q1 was 20% and Q2 was 32%

So based on Group selection from Filter, the time series (vertical bar) chart should show the Quarterly value in % 

Below Solution I tried but didn't work:

1) Created Two Automated indicator, one to get total tasks count (without any breakdown) and other with same source but with breakdown as assignment group. Also created third formula indicator with breakdown as assignment group Formula: (total tasks with breakdown/total tasks)*100.

Here the filter is not getting applied as one of automated indicator is without breakdown.

Any suggestions/working solution is greatly appreciated.

[luffy3478]

By default, breakdowns in ServiceNow display counts. However, try to modify the breakdown script to calculate percentages instead.

[RiteshSwarnakar]

Hi @luffy3478 ,

Thanks for your response, but could you please let me know what script and where it needs to be written?

I don't find any option for scripting in breakdown, did you mean indicator?

[luffy3478]

Sorry, my mistake. Not sure, how we can achieve this small requirement