Hi, I want to display max time as to when data is ingest to DB to subtitle. 1st, I made the custom field for MAX (tts) on a field that has a timestamp in. Then I changed this to String and made parameter and attach it to the subtitle. Just instead of displaying MAX timestamp, it displays “ALL”. If …

Hi @matjazz Sorry for the confusion. The reason it says ‘All’ is because it’s technically not filtered, even though in your case, all the values should be the same. You would need to control the parameter by a control (don’t think this is possible in your case since it’s self referencing), or a dy…

You need to make a dataset with users and maxTTS. This will link all users logged in to that maxTTS. For more information you can check out this. [image] How to make Dynamic parameter Question & Answer If I open dashboard it should reflect current date in parameter,is it…

H @Max , my goal is to display last date when data was inserted to SPICE. So in case that incremental refresh fails, people can see that there isnt updated data in DB. With maxTTS this is easily done, just can’t be displayed in the Title or Subtitle of the page which is my goal.

Yep you need to make a dynamic parameter to reflect the maxTTS

Hi @matjazz This article should help show how to display parameters in titles. Using parameters in titles and descriptions in Amazon QuickSight - Amazon... Use parameters in chart titles and subtitles, axis titles, chart legend titles, parameter control titles, and sheet titles and desc…

@bergqdou Yes, I did that already and I understand how parameters work. My issue here is that when I try to display the MAX value of one column it is displayed ok on all charts. Just at title displayed with parameters instead of value it says “All” as seen in the 1st picture, so it doesnt display va…

MAX tts in title

Q&A

Max May 5, 2023, 3:16pm 2

You need to make a dataset with users and maxTTS. This will link all users logged in to that maxTTS. For more information you can check out this.

Topic		Replies	Views
Parameter Simple calculations Q&A analysis , parameters , quick-sight , visuals , calculations , Business-Intelligence-Engineer	7	130	June 13, 2024
Show Maximum Date in Dataset in Title Q&A quick-sight	9	1094	May 24, 2023
Assign maximum value to String parameter(Date) Q&A quick-sight	5	1430	September 5, 2025
Representing calculated field in KPI using parameter Q&A visuals , Business-Intelligence-Engineer	3	23	February 20, 2026
Dynamic date change in the title Q&A parameters , quick-sight	7	2121	August 15, 2023

MAX tts in title

Related topics