Bihistogram in Tableau

2
votes

I'm attempting to create a bihistogram in Tableau and running into trouble getting the formatting right. I was able to create a dual axis chart from the two sets of bins I want to compare and dropped in two measures, the count of records in each bin and the sum of a calculated field that contained just -1. That gets the reflected look I want but both measures show up on both axes of the chart. I'd like to be able to specify that one of the measures should only be shown on one axis and the other measure on the other axis. Is this possible?

The data is structured as follows:

| Expected Duration | Actual Duration | Expected Duration (Bins) | Actual Duration (Bins) |

2
tableau-api
post sample data – Alex Blakemore
If you mean not to see the axis on one side, you may do this by unticking "Show Header" on the right click menu of the axis. Otherwise sharing some sample data and/or the .twbx containing sample data with what you have done so far would be helpful as @alex-blakemore mentioned. – Hakan ERDOGAN

2 Answers

1
votes

I'll explain how this is done via reversing the AXIS

  1. Your shelf would look like this -

Header

  1. This will result in this - 2nd
  1. Edit the axis

Edit Axis

  1. and check the Reversed tick

enter image description here

  1. The result image will lead to bihistograms BIhistogram

If you need the TWBX file, let me know I can upload it somewhere.

0
votes

yes, there is options to change what you needed, just right click on any of the axis and you will get the option.