
1. Re: Trying to subtract histograms from each other
jordan.bunker Jan 21, 2014 6:26 PM (in response to John Kanady)Hello John,
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!
 Jordan

Histogram test  REVISED.twbx 68.6 KB


2. Re: Trying to subtract histograms from each other
John Kanady Jan 21, 2014 10:02 PM (in response to jordan.bunker)Absolutely fantastic! Thank you kindly, Jordan! It was driving me batty trying to find a method to make it work.
Very much appreciated,
 John