Looking to create a benchmarking bar chart showing +/- % from prior year

Stephanie_Price

I am wanting to create a bar chart similar to below. I want the +/- % to be based on prior year CPM. I am not seeing a bar chart that would operate similarly to this - does anything have any experience with this? Thanks

DashboardDude

Hi @Stephanie_Price ,

I made you a video on how I would approach this and it's very possible: https://www.loom.com/share/471ff098966f4c7fac7684fcb96d366a?sid=d9157b01-798f-4323-a858-09d66511acd6

I had to make some assumptions like @ST_-Superman-_ was asking, but I think we got it.

ST_Superman

This would depend on how your dataset is structured. Could you share some more info about your data? Is the prior year benchmark in your dataset already? Or would that need to be calculated as well?

I'm pretty sure this is doable with a beastmode and a trellis category.

DashboardDude

Hi @Stephanie_Price ,

I made you a video on how I would approach this and it's very possible: https://www.loom.com/share/471ff098966f4c7fac7684fcb96d366a?sid=d9157b01-798f-4323-a858-09d66511acd6

I had to make some assumptions like @ST_-Superman-_ was asking, but I think we got it.

Stephanie_Price

Hey @DashboardDude, thank you so much for the video. This chart is in backlog now as I need some more information from team members, but I have this bookmarked for when I'm ready to reapproach.

I'll see you at DomoPalooza - I've checked out your page and love your approach to teaching - very interesting. Excited to hear you speak.

Thanks!