I have attached a revised version of the workbook provided which demonstrates how to create the desired view.
In order to build the view, I have separated the CNT(Adjusted Tau) table calculation into two separate calculated fields (one for each Genotype) using the formulas below:
(Both table calculations were set to Compute Using > Adjusted Tau (bin))
I then created a new calculated field with the following formula:
This calculated field is also a table calculation, and its Compute Using settings are set as shown in the screenshot below:
Then I created a final calculated field to color the bars based on whether they were negative or positive:
Finally, all three table calculations were dropped on to the Rows shelf, and the color calculated field was placed on the Color shelf for the difference calculation.
Hope this helps!
Histogram test - REVISED.twbx 68.6 KB
Absolutely fantastic! Thank you kindly, Jordan! It was driving me batty trying to find a method to make it work.
Very much appreciated,