3 Replies Latest reply on Mar 29, 2018 11:16 AM by John McGuirk

Display most recent calculated z score measures in a crosstab

John McGuirk Mar 29, 2018 7:13 AM

Hi,

I need to create a crosstab view showing only the most recent calculated z score value and then sort by the z score values. The view should look like this.

Z score C -1.01

Z score B -1.592

Z score A -2.707

I have tried using LOD calculated fields but I received error messages that I couldn't use an LOD on a table calculation. I also tried using other functions like LAST and MAX with no success. My workbook example is attached. Any ideas would be greatly appreciated.

ZscoreExample v10.2.twbx 38.2 KB

1. Re: Display most recent calculated z score measures in a crosstab

Deepak Rai Mar 29, 2018 10:55 AM (in response to John McGuirk)
Hi John,
Here it is, You need to First Pivot your data and then have to use LODs for A, B, and C and then Filter across for Last Value to get this:
Thanks
Deepak

ZscoreExample_DR.twbx 76.6 KB
Like Show 0 Likes(0)

Actions
2. Re: Display most recent calculated z score measures in a crosstab

Deepak Rai Mar 29, 2018 11:01 AM (in response to John McGuirk)

Hi John,
After posting above, I went back to your sheet and realized that it was just matter of filter for MAX Value. So you may pick up whatever you need. This is from your Sheet 1.
2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Display most recent calculated z score measures in a crosstab

John McGuirk Mar 29, 2018 11:16 AM (in response to Deepak Rai)

Hi Deepak, this is great. Thank you! Your second solution is obviously easier but I appreciate your LOD solution as well. I would never have been able to come up with pivoting the data in an LOD calculation on my own. I will be doing some research on pivoting the data so I can use it going forward. Thanks again.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Display most recent calculated z score measures in a crosstab

1. Re: Display most recent calculated z score measures in a crosstab

2. Re: Display most recent calculated z score measures in a crosstab

3. Re: Display most recent calculated z score measures in a crosstab

Actions

More Like This