3 Replies Latest reply on Jul 17, 2017 5:43 PM by Chris McClellan

Return a text name

Alex Martino Jul 17, 2017 3:41 PM

If I have a parameter 1,2,3,4 etc, how can I get a text box to change to month name based on the numbers? Thanks.

1. Re: Return a text name

Peter Fakan Jul 17, 2017 4:05 PM (in response to Alex Martino)

Hi Alex,

If I understand your requirement properly, create a calculated field using the following syntax:

Case [Parameter name]
when "1" then "January"
when "2" then "February" ~etc
end

Then insert this calculated field into your text box

HTH

Peter
Like Show 0 Likes(0)

Actions
2. Re: Return a text name

Alex Martino Jul 17, 2017 4:56 PM (in response to Alex Martino)

Thanks. Is there no date function that will convert a number into a month?
Like Show 0 Likes(0)

Actions
3. Re: Return a text name

Chris McClellan Jul 17, 2017 5:43 PM (in response to Alex Martino)

But "1" isn't really a date, does 1 mean the first month of this year ? calendar year or fiscal year ?

You can take the "1", and add in the other values as part of the MAKEDATE function, but why not just have the user choose the date in the parameter ?
Like Show 0 Likes(0)

Actions

Tableau Community