I would like to assign a simple calculation to a parameter, e.g. latest date in a column or maximum value of a category. Is this possible in Quicksight?
Reason for asking: I have a dashboard, for example, in which I have the data over several years on a monthly basis. Now there are some charts that always refer to the current MAT. Here I would like to integrate a parameter in the chart title that shows the MAT, e.g. “Turnover at product level - MAT 2024/06”.
Many thanks for the quick response and the suggested solution. Unfortunately, the solution does not work because the available data does not always contain the current month. The data can sometimes be one or even two months in the past. Therefore, I think you need the possibility to determine the maximum value of the Date column in the parameter. And unfortunately that is not possible, is it?
I am not quite sure whether I have understood the proposed solution correctly. If I create a calculated field with the suggested code, I get the maximum date contained in this field. However, if I then add this to a parameter and use it in a title of a graphic, only “All” is displayed instead of the date.
However, my aim is to get the maximum date of the data set in the title of the graphic.
One approach can be to plot a wordcloud of the calculated field. You will get a plot like the screenshot. You can drag this plot to the top of the analysis and place next to the title. Will this work?
But at my Dashboard only some Visuals are based on MAT. Others can have only one ore sometimes 15 Months. So to differ the related datas for each Visual the MaxDate should be in the titel of the Visuals.
Ok. So, an idea to accomplish that would be to overlay the wordcloud and adjust the size of it on top of the visuals where you want this calculated field to be displayed.
