I have data with organized by week, but for different user the data will be updated at different times. How do I show the maximum report date applicable to each user as a parameter in a title?

Hi @cactus Wondering if a simpler approach could work. Maybe creating a custom field calculating max date and just displaying that field might work. See below. 1- Create calculated filed to get max date. [image] 2- Create pivot table with only one value - maxdate. Style to make look nice. [i…

Hi @cactus - Can you please check the below link, [image] Time Stamp Question & Answer Hi @nitishpala - Can you please follow the below steps. Step -1 : At data set level, add a calculated field and paste now() for the value. See the screen shots below. Step -2: At Anal…

Hi @cactus - Not sure whether this is possible or not. I believe depending upon the user the max report date needs to be populated as the Title of the report. hi @Max @David_Wong @Ramon_Lopez - Need your expert advise on this? Regards - Sanjeeb

Thanks @Ramon_Lopez . The challenge is the max date may change from user to user and when the user will login, the report should show the max date for that user. Hi @cactus - Please correct my understanding about the requirement. Regards - Sanjeeb

hi @Sanjeeb2022 My thinking with that is to achieve user specific data they either have RLS or filters in place. when filtering it would get the max date for the data available. @cactus lets us know if im missing anything. Thanks! Ramon

These both make sense - thank you!

Hi, @cactus . If one of these works for you, can you mark that reply as a Solution (click the check box under the name)? That will really help our Community out. Thanks!

Show Maximum Date in Dataset in Title

Q&A

Sanjeeb2022 May 21, 2023, 4:06pm 2

Hi @cactus - Can you please check the below link,

Regards - Sanjeeb

Topic		Replies	Views
Parameter Simple calculations Q&A analysis , parameters , quick-sight , visuals , calculations , Business-Intelligence-Engineer	7	132	June 13, 2024
Dynamic date change in the title Q&A parameters , quick-sight	7	2147	August 15, 2023
MAX tts in title Q&A quick-sight	6	529	May 15, 2023
Creating max date available as default filter Q&A filters , quick-sight	5	5188	February 2, 2023
Why is showing the Max Date so difficult? Q&A feature-request , quick-sight	8	3988	March 25, 2025

Show Maximum Date in Dataset in Title

Related topics