
1. Re: Plotting calculated correlation coefficient
Richard Leeke Jan 5, 2012 1:57 AM (in response to . Ck.)What you need to do is arrange for Tableau to see all the details it needs to calculate the correlation coefficients (by having the date, month and identifier dimensions in the view, as you have) but only include the correlation coefficient measure in the view. That almost gives you what you want  but you have multiple rows for each city/month combination (one for each identifier).
So you need a filter which acts after the calculated field has been evaluated to limit it to one row per city/month. You can't just filter on identifier or Tableau wouldn't see all of the rows it needs. The trick here is that filters on table calculations are not applied until after table calculations have been evaluated. You can just define a field using the INDEX() table calculation function and display just the first row of each partition (say) using a filter on that calculated field. Example attached.

tableau_corrcoeffeg_rl.twbx 19.6 KB


2. Re: Plotting calculated correlation coefficient
. Ck. Jan 5, 2012 1:53 PM (in response to . Ck.)Thank you sir  that is exactly what I was looking for. Greatly appreciated..

3. Re: Plotting calculated correlation coefficient
gabrielgriggs0 Mar 2, 2012 1:32 PM (in response to Richard Leeke)Hi Richard,
I am working on a problem that is similar to this one (as far as I can tell).
Can you think of a way to do this: http://community.tableau.com/thread/116245 ?
Thanks,
Gabe