How to calculate percent changes?

Comments

1 comment

  • Avatar
    maria_lucas

    Hello,

    I'd recommend starting by building your data query in the Industry Explore by filtering for State: Georgia. Then, filter and pivot on Data Year, including each of those Data Years you've listed. Finally, click/select the Employment Measure and the Industry Dimension you'd like to include in the query and run. 

    To calculate the change from one Data Year to another (listed as columns), you'll need to add a Table Calculation, by clicking the Calculations button available along the top of the Data query field. 

    This formula will calculate the change in Employment from column 1 (Year 1: 2017) to column 2 (Year 2: 2018) in each row. Notice below "1" and "2" refer to the column numbers. Add a Table Calculation for each change percentage and make the appropriate change to these values:

    (coalesce(pivot_index(${market_data.total_employment},2),0) - coalesce(pivot_index(${market_data.total_employment},1),0)) / (coalesce(pivot_index(abs(${market_data.total_employment}),1),0)
      )

    Best,
    Maria

    1
    Comment actions Permalink

Please sign in to leave a comment.