Data Studio
4.6K members online now
4.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Plot YoY Change in Graph

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I need to plot Year on Year Data on Data Studio in a Bar graph. What is the best way to do this?

 

Thanks

Sakshi

Re: Plot YoY Change in Graph

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Hi @Sakshi C,

You can select dimension as Year and the metrics (you want). Apply the date range 2014-2017. Sort the dimensions

GoogleDoubt-20.png

Hope this helps,

Thanks,
Ritwik

Plot YoY Change in Graph

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Ritwik,

 

Thanks for your reply.

 

I actually need to plot the YoY Change Absolute Value (This years cost - Last Years cost ) daily in a line graph.

 

Would you know how to do that ?

 

Thanks

Sakshi

Re: Plot YoY Change in Graph

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

Hi @Sakshi C,

Ohk. I actually use scorecards to show comparison. Like I create scorecards each for a date range Jan - Dec and then compare with previous year. There are also option to show absolute values instead of % change. You can check it out.
You can use line graph too with metric cost and dimension as Year
I have shown bar graph here

Also there might be some other good methods out there to visualize this.

GoogleDoubt-20.png

Hope this helps.
Thanks,
Ritwik

Plot YoY Change in Graph

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi Ritwick,

 

In the example you have above, it appears you are using conditional formatting in your score cards. Would you mind explaining how you were able to change the font color(red or green) for your % change values?

 

Thanks,

Charles

Plot YoY Change in Graph

Follower ✭ ✭ ☆
# 6
Follower ✭ ✭ ☆

Hi Sakshi

 

Do you have This years cost & Last Years cost as two seperate metrics? If so you could add a simple calculated metric to give you that?

 

 

Hi Charles

 

The scorecard does that formatting for you.

 

Rob