% Change month over month..

Oneimus
Tera Contributor

I am trying to create a similar report in PA that compares Current Month to Previous Months and provides a % difference. Similar to this.

find_real_file.png

6 REPLIES 6

I believe I follow what you are saying but there are a couple questions.

I have written it out step by step to help me.. 

1. Create New Indicator Source
     a. Navigate to Sources > Indicator Source
     b. Click New
     c. Section - Validity for Indicator frequency
         i. Set Valid for frequency = MONTHLY
     d. Section - Source 
         i. Report Source
         ii. Facts table
         iii. Conditions
     e. Tab - Records View & Records Collection - accept Defaults

2. Create an Automated Indicators
     a. Navigate to Indicators > Automated Indicators
     b. Click New
     c. Section - Indicator properties, what is recommended for this:
         i. Direction
         ii. Key
         iii. Unit
         iv. Precision
     d. Tab - Source
         i. Set the Indicator source
         ii. Aggregate = AVERAGE 

3. Create New Widget
     a. Navigate to Performance Analytics > Widgets
     b. Click New
     c. Fill-in Name and select Indicator
     d. Set Type = Time Series
     e. Set Visualization = Column
     f. (Tabs) is there anything specific that needs to be selected?

4. Create Job
     a. Navigate to Data Collector > Job
     b. Section - Collection parameters {Wasn't sure which need to be 30- and 0}
          i. Operator = Relative
          ii. *Relative start = ?
          iii. Relative start interval = ?
          iv. *Relative end = ?
          v. Relative end interval =?
     c. Section - Job parameters
          i. Run as = System Administrator
          ii. Run as tz = US/Central
          iii. Active = true
          iv. Run = Daily
          v. Collect = Both scores and text index
          vi. Time = 17:00:00
          vii. Conditional = ?

*Relative start = ?- 12

Relative start interval = ? - months

Relative start interval = ? - 0

Relative end interval = ? - days

in widgets you don't need to select tabs 

when it comes to conditions you can not give in jobs rather you can give in indicator sources and after you run this job daily go to the analytical hub and click on compare you can see the difference of data