Percent increase/decrease

Reply
Yellow Belt

Percent increase/decrease

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!

 

Highlighted
Major Brown Belt

Re: Percent increase/decrease

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
______________________________________________________________________________________________
Yellow Belt

Re: Percent increase/decrease

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 

Announcements
New to Dojo Please update your Dojo handle and personal settings. Click here!