Changing default name of "All" when it comes to parameters?

I’m using the parameters to adjust the title of my tables and graphs. The problem I’m running into is that I don’t want “All” as the default name for all of the selections. I’d like it to be All Properties. I don’t want to add “Properties” after the ${propertyselection} parameter because there will be single selections in some cases by the user of the dashboard.

How I’m naming the titles:

What gets displayed:

Hello @jp207 !

Could you try adding a calculated field like this one?: ifelse(${propertyselection}>1, 'Properties','Property')

Let me know if that works!

1 Like

Hi @duncan,

That did not seem to work for me. This is the error I get:

Expression ifelse(${propertyselection}>1, ‘Properties’,‘Property’) for function > has incorrect argument type String List > Number. Function syntax expects ‘<COMPARABLE_TYPE> > <COMPARABLE_TYPE>’.

It does not look like the ${propertyselection} parameter can be “counted”. So if one were to select all or select multiple selections for the propertyselection, that ifelse statement you gave would not work.

I also don’t know how I would get a calculated field to show up in a visual’s title. You can only place a parameter into the title.

image

Hey @jp207 ,

After looking into this more and trying different solutions, I don’t believe its possible stop the Select All of a parameter from coming back as All in the chart title. I also checked Using parameters in titles and descriptions in Amazon QuickSight and it looks like the most it allows is to use the parameter selection but not make changes to that.

3 Likes