Multi card axis syncing

Options
G_Grey
G_Grey Contributor
in Other Ideas

Aiit so here I am, I decided to go out on my own and describe the types of products at my company. We sell Mugs and... Not... mugs

image.png

Here's my intimidatingly complex dataset

image.png

We have all been in this situation where we want to compare one card to another card... and here we are again. Usually it's for a more complex reason though other than arbitrary separation of cards. My CEO is going to be outrageously impressed with my bi swagger. As you can see mugs are our second best selling product.... Except wait.... no, they're not! One chart has an axis of over NINE THOUUSSSAANNNDD and the other one is less. Memes and Mugs sell almost the same amount.

image.png


What to do? Well, if I set a max on each chart's scale then if I want to filter on colors of mugs in my even more complex dataset that hypothetically exists here then the chart will look super squashed because the scale isn't dynamic anymore.

If there were functionality built to keep the axis's both in sync then the cards could work in tandum to tell a super powerful and interactive story. Bonus points if we can design linked drill paths so if you drill into one it drills the other linked cards as well.


image.png


3
Up
3 votes

Active · Last Updated

Comments

  • Neko
    Neko Member
    Options

    Hello! I don't know if you've already solved this yet but I was having the exact same problem today and it took me to your post when I was searching for the solution. I'm glad that I'm not the only one who was running into the same problem!

    Here is what I came up with:

    2023-01-31_21-32-53.png


    First, I calculated Max Sales per Product then I added 100 to the Max Sales as shown below. ( I will explain why I added 100 later. You will see...hehehe)

    image.png


    On the Cards, I used Line bar and applied Max Sales to Y axis (No aggregation) and Sales to Series (Sum).

    2023-01-31_21-42-33.png


    Then in the chart properties, I marked Hide Second Scale and Sync Value Scales in General.

    2023-01-31_21-45-13.png


    I also hid Landscape View Legend Position and Portrait View Legend Position.

    2023-01-31_21-45-44.png

    Lastly, I changed the opacity of Max Sales of the color to ZERO so it would be invisible.

    2023-01-31_21-46-42.png


    Apply this technique to all of the cards so they will be standardized.

    However, this results in a small rendering bug as shown below. The invisible line is slightly visible on the tallest bar.

    2023-01-31_21-30-48.png


    That is why I added a small number to the Max Sales (wink).

    There is one thing that you need to be aware of. When you hover your house over the line, the value of the invisible line will appear. So don't move your mouse when you show this to your CEO. Your swagger will remain intact.

    2023-01-31_21-33-10.png


    I hope this will be helpful. Or please share your ideas if you've solved it!


    Thanks!

Categories