Percent increase/decrease

Lara
Lara ⚪️
in Charting

Hello,

 

If I have many columns for ex: "2010 population" "2012 population" "2014 population"

and I would like to show the % evolution between each of them  on the graph how can I do it?

 

Thanks!

 

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🟤

    I think that you would need to create a beastmode calcualtion for each time frame you wanted to compare.  For example, to compare 2012 to 2010:

     

    (SUM(`2012 population`)-SUM(`2010 population`)) / SUM(`2010 population`)

     

    You would then want to format the chart to display as a percent.


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • Lara
    Lara ⚪️

    thank you for your help ! I did the beast mode calculation 

    what I am still trying to do is combine the both the value and percent change

     

    my data is formatted that way

    1 row is one city  and the columns represent the population of diferent years 

    i am trying to filer by city and then add as bars the sum of population and lines the % evolution,

    but I guess this is not feasible in one graph 

This discussion has been closed.

Categories