Percent Increase Decrease

Lara
Lara
in Magic ETL

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?

 

If beast mode is the way to do it I will then have 3 columns  "2010 population" "2012 population" "2014 population"

then 2 columns "10/12 Evolution" "12/14 Evolution" is there a way to put them in on graphs (bar + line)

 

Thanks

Best Answer

  • PodiumMason
    PodiumMason
    Answer ✓

    Hey @Lara,

     

    Based on your description, this should be fairly easy to do especially if they are already living in their own columns. 

     

    I would create a separate beast mode for each evolution you want to view and then put them all on a stacked or grouped bar chart. You can add all the columns as separate series on the graph and view them side by side. 

     

    Let me know if this is helpful or if you have additional logistical questions.


    Best of luck!

     

     

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • PodiumMason
    PodiumMason
    Answer ✓

    Hey @Lara,

     

    Based on your description, this should be fairly easy to do especially if they are already living in their own columns. 

     

    I would create a separate beast mode for each evolution you want to view and then put them all on a stacked or grouped bar chart. You can add all the columns as separate series on the graph and view them side by side. 

     

    Let me know if this is helpful or if you have additional logistical questions.


    Best of luck!

     

     

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Categories