2 Replies Latest reply on Apr 17, 2012 8:28 AM by Heather Campbell

Parameter sort using dimensions and measures?

Heather Campbell Apr 16, 2012 10:47 AM

I am trying to allow the user to select a "sort by" using a parameter - based on the advice from this thread http://community.tableau.com/message/128378#128378

However, I would like the Sort to include several dimesions and two measures but I can't use both data types in the CASE statement. Are there any solutions to sort by dimensions and measures? (screen shot attached)

Thanks!

Sort by dimension and measure.docx 416.1 KB

1. Re: Parameter sort using dimensions and measures?

Tracy Rodgers Apr 16, 2012 4:36 PM (in response to Heather Campbell)

Hi Heather,

One possible option would be to change your measures to strings. By placing str() around the measures in the formula, the calculation should be valid. Hope this helps!

-Tracy
Like Show 0 Likes(0)

Actions
2. Re: Parameter sort using dimensions and measures?

Heather Campbell Apr 17, 2012 8:28 AM (in response to Tracy Rodgers)

Thanks Tracy -

I've tried this but then Tableau tries to sort by measures as a string not as a number.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Parameter sort using dimensions and measures?

1. Re: Parameter sort using dimensions and measures?

2. Re: Parameter sort using dimensions and measures?

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account