Running a Data Collection job for a formula indicator in Performance Analytics

Farrah1
Kilo Contributor

I created a formula indicator that takes one indicator... divides by 8... an then multiplies by another indicator (see below)

[[Farrah Sum of  OH IS Time Worked]] / 8 * [[Farrah OH IS Users]]

I named this formula indicator "Farrah % of OH IS Time Worked"

When creating a Data Collection Job for this formula indicator, when I scroll to the bottom and go to the "Indicators" tab, this formula indicator does not show up (see screenshots).  Should it show up (I mean, if I don't choose and indicator, how is the job going to know what to run)?  All that shows up are the two auto-indicators I created (but not this formula indicator)

 

 

1 ACCEPTED SOLUTION

jeffrubinoff
ServiceNow Employee
ServiceNow Employee

Except where I wrote "It's a good idea to collect scores on the formula indicators in the same job," I meant "It's a good idea to collect scores on the automated indicators in the formula in the same job." Even I get confused writing about this stuff, and I'm the tech writer!

View solution in original post

6 REPLIES 6

jeffrubinoff
ServiceNow Employee
ServiceNow Employee

Hi Farrah,

You don't create data collectors for formula indicators. You only collect on automated indicators. So for a formula indicator, you collect on the automated indicators in the formula, and the formula calculates the score for the formula indicator. It's a good idea to collect scores on the formula indicators in the same job, if they are on the same indicator source. If this is not possible, try to schedule the collection jobs as close to each other as possible.

Thank you very much! 🙂

jeffrubinoff
ServiceNow Employee
ServiceNow Employee

Except where I wrote "It's a good idea to collect scores on the formula indicators in the same job," I meant "It's a good idea to collect scores on the automated indicators in the formula in the same job." Even I get confused writing about this stuff, and I'm the tech writer!

LOL... no worries.  It's a LOT!  Thanks again for the help!