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
Red 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
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!