Show Maximum Date in Dataset in Title

[cactus]

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?

[Sanjeeb2022]

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

Time Stamp

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 Analysis level, Add insight, select the date field in the dimension, edit the narrative and put t your narrative. and save it. Edit the title and sub-title. See the screenshot. [image] [image] [image] hope this is what you are looking for. Regards - Sanjeeb

Regards - Sanjeeb

[cactus]

I think this is close but not quite it. I do not want the last refresh date, I want the maximum date in my dataset (and for it to respond to any filters I put on it). Consider a dataset

|Customer|Report Date|Sales
Cust A | 1/6/2023|$2M
Cust A | 1/13/2023|$2.5M
Cust A | 1/20/2023|$3M
Cust B | 1/6/2023|$2M
Cust A | 1/13/2023|$2.5M

If I am not filtering for customer I want to be able to show “1/20/2023” in some of my titles as it would be the most recent value.

[Sanjeeb2022]

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

[knamburi]

@cactus

|Customer|Report Date|Sales
Cust A | 1/6/2023|$2M
Cust A | 1/13/2023|$2.5M
Cust A | 1/20/2023|$3M

@cactus It seems you would need the parameter be set per user. I would recommend dynamic default parameter (DDP) for this usecase? Please follow instructions in this link. Hope this helps. Creating parameter defaults in Amazon QuickSight - Amazon QuickSight

[Ramon_Lopez]

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.

2- Create pivot table with only one value - maxdate. Style to make look nice.

Let me know if this won’t work and we can keep brainstorming.

thanks!
Ramon Lopez

[Sanjeeb2022]

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

[Ramon_Lopez]

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

[cactus]

These both make sense - thank you!

[Kristin]

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!