How can i change the titles in a quick Sight dashboard without embeded

Q&A
, , ,
1

I tried some solutions from here but nothing works.

  1. Try

I have a dataset with all attributes different columns for ever needed languages. i have a dataset parameter for the selected language. then i added calculated fields for every attribute to the dataset

maxOver(
  ifelse(
    ${TranslateLanguage} = 'DE', {German},
    ${TranslateLanguage} = 'EN', {English},
    {German}
  ),
  [Attribute='Amount/Value'],
  PRE_FILTER
)

but the maxOver don’t work. if i only use ifelse i get a result

  1. Try

I have a dataset with different columns for every attribute. and the language is in a row.

Every Time when i use the Values in a Parameter then i get only ‘ALL‘ how can i configure the parameters that i get only the first value.

thanks for helping

2

Hi @sandy.hagewald and welcome to the Quick Community!

Based on how you explained your scenario, I would recommend looking at this resource as I think it walks through your same scenario or a very similar one that you can refer to (Build a multilingual dashboard with Amazon Athena and Amazon QuickSight | AWS Big Data Blog). Check this out and let me know how it goes or if you still have questions!

3

Hello, i don’t want change the language of analytics data. I only need to change titles. i try this without embedded views. If i use the language dataset in Parameters i get every ‘ALL‘ as result.

4

Hello I have now come up with a temporary solution. I change the languages using the actions of a table object. I populate the table using an SQL query that contains only one input parameter. For each language, I use an action to update each individual parameter with the translations. Unfortunately, this is a manual process. Unfortunately, Quicksight does not support automatic parameter population via datasets, as is possible with other analytics tools.

5

Hi @sandy.hagewald ,

That is a great workaround. Apologies on the confusion from my previous reply. The difficult part with titles is that it is a manually created value from the user. Then to have a visual title to be able to change, it is only done through parameters. However, even with this approach it is still a manual process.

if you’d like, I can attach the ‘feature-request’ tag to this post to help increase visibility to the Quick Team in regard to quicksight supporting automatic parameter population via datasets feature.

6

Hello,

it is a feature request.

The best solution would be if I could get just the single value back in a dataset filled single-value parameter instead of “ALL.” Then I could dynamically populate it with a dataset.

This would also work correctly if I wanted to add languages. As it stands, for every additional language, I have to create a new action with each parameter instead of simply expanding the dataset and then filtering it accordingly. Working with many parameters in actions is always tedious because they are often not sorted.

7

Hi @sandy.hagewald ,

Those are great points. I took off the solution for this post and added the ‘feature-request’ tag. I will have to mark this post as complete so it can be seen on the system support side. With that said, if you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you