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

Stephanie_Price · January 2024

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 · January 2024

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 · January 2024

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 · January 2024

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 · February 2024

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!

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

Best Answer

Answers

Categories