can I use calculated fields in Performance Analytics

[klemmyjb1]

I have some calculated fields in excel which i will like to create in Performance Analytics

[Adam Stout]

You can use a PA Script to do this in most cases, but before you do this, you should consider if you want to report on this or use it in interactive filters.  You may want to add a calculated field to the main object or even better a glidefunction field or a field calculated by a business rule.  This will be able to be used in PA but also every place else from interactive filters and reporting to other business rules and workflow.

[klemmyjb1]

Thanks Adam,

I am a power use not a developer and still very new to PA, who will set up the PA Script or  add the calculated field to the main object glidefunction field or a field calculated by a business rule. 

[Adam Stout]

You need to be a pa_data_collector or pa_admin to write a PA Script.  To add a new field (which is the path I normally recommend but depends on your requirements), you need to have admin access.  This is normally done on a sub prod and moved like any other app change.

[Josh Cooper]

You would definitely need a ServiceNow Developer (or someone with that admin role) to set up the calculated field, glidefunction field or field with a business rule.  That said, it's not super difficult or time consuming, has more to do with permissions.

PA Scripts can be done with PA Admin, but they use the same javascript style as the business rules and all, so there's a little barrier to entry.  If you're already good with Excel functions and formulas, then I don't think there's anything preventing you from being successful.

The consideration is, as Adam said - the PA Script is going to run with the job, nightly, and it'll be subject to the breakdowns you apply to it.  But if you're wanting it to respond to interactive filters and update throughout the day, etc, then you really want to report on it, which means some sort of field on the table itself.  

Once the field is on the table, you can then point PA at it for long term trending and score retention, etc.