9 Replies Latest reply on Jun 11, 2018 7:21 PM by Shinichiro Murakami

# Two Way Dual Axis

Is there a way to create a two way dual axis? By that I mean, I have two date columns that I can add to a dual axis. I also have two measure that I want to display and can put on a dual row axis. However, I cant specify which measure should show on the first date axis and which should show on the second. Both measures show on both date axis which just creates a mess.

It table view, that would be like hiding a quandrant.

• ###### 1. Re: Two Way Dual Axis

HI Kate

It's quite difficult to understand your issue without seeing your data.   Could you please attach sample data as twbx format, and illustrate your problem and expected result.?

Thanks,

Shin

• ###### 2. Re: Two Way Dual Axis

Here is a general idea. I don't have a workbook for it. But, I have two dual axis, one set in columns and one in rows. In the pic below, I only want to show sales on the order date axis and  only show profit on the ship date axis. However, there doesn't seem to be a way to specify. So instead of having one measure on each column axis, I have duplicates.

• ###### 3. Re: Two Way Dual Axis

Hi Kate,

You can create a double dual-axis viz, but as shin said we'd probably need to see it to be able to comprehend if what you are attempting to do is possible.

Simply double the measures/dimensions you want to quad axis out onto the rows and columns shelf though, 2 on rows, and 2 on columns, and then dual axis them both to get an x/y and top/bottom axis.

Fair warning too, they are supremely difficult to understand and you will probably achieve better results by splitting up your viz.

HTH

Peter

• ###### 4. Re: Two Way Dual Axis

Hi Kate,

I have applied sum(sales) to the order date

and sum(profit) to the ship date

Is this what you are looking for ?

HTH 18.1 attached

Peter

• ###### 5. Re: Two Way Dual Axis

HI Kate,

In this case, your have two different "date" fields and I don't recommend to use simple dual axis.

Considering further analysis like delta between sales and profit or parentage calc, you had better create unified "date" filed to plot both data on same chart.

Other than that, assuming you use order date as primary, if some order date does not match to any ship date, the ship date's profit data is lost.

Thanks,

Shin

• ###### 6. Re: Two Way Dual Axis

Not quite. Based on the colors, sales and profit are on both axis.

I am looking for a single sum of profit line for quarters and bars with just sales data for weeks.

• ###### 7. Re: Two Way Dual Axis

Here  you go.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 8. Re: Two Way Dual Axis

re-posting to adjust the time stamp.

Here  you go.

Thanks,

Shin

1 of 1 people found this helpful