Andrew S
Andrew S

Reputation: 85

Bihistogram in Tableau

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) |

Upvotes: 2

Views: 121

Answers (2)

Mohammed Mohsin
Mohammed Mohsin

Reputation: 21

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

Upvotes: 0

Pirate X
Pirate X

Reputation: 3093

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.

Upvotes: 1

Related Questions