YoY Chart

domoexpert

I want to create a YoY line chart with Time on the x axis, YoY change on the Y axis and Year in the series. So it would have 3 lines for the years E.G 2021,2022,2023

How can i do this?

MichelleH

@domoexpert I'd suggest using a Variance Trendline card under the Period Over Period chart types, though note that these types of charts do not offer much customization

GrantSmith

Alternatively for a more customizable data solution you can utilize a custom date offset table and gives you a bit more flexibility graphing data than the standard PoP charts. I've done a write up on this before here:

A more flexible way to do Period over Period comparisons

GrantSmith

Sep 21, 2021

Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in the previous period (no more seeing your period over period percentage tank because the month isn't complete yet). I will also go over how to configure and set this up yourselves. Let's get started.

---

View Post

MichelleH

@domoexpert I'd suggest using a Variance Trendline card under the Period Over Period chart types, though note that these types of charts do not offer much customization

GrantSmith

Alternatively for a more customizable data solution you can utilize a custom date offset table and gives you a bit more flexibility graphing data than the standard PoP charts. I've done a write up on this before here:

A more flexible way to do Period over Period comparisons

GrantSmith

Sep 21, 2021

Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in the previous period (no more seeing your period over period percentage tank because the month isn't complete yet). I will also go over how to configure and set this up yourselves. Let's get started.

---

View Post