Dynamic date change in the title

Question & Answer
,
1

Hi,
I have an overview table in my visual 1 & this table do not have a daily feed into it. Let’s say the latest is Sep 30. I have my visual 2 and it also displays the latest data based on visual 1.
However, I want to display title in my visual 2 “Data as per: Sep 30”
I want this title to be dynamic, if the latest data is Oct 2nd, the title should say “Data as per: Oct 2”
I tried with parameters it did not work. Is there any work around?
Appreciate the help. Thanks

2

You may use dynamic default parameter by user group to achieve this. Not a perfect solution but it should work in the use case you mentioned. steps as below

  1. Create user group. For instance “Default-ReaderGroup” and add all users to this group
  2. Create a dataset by using custom SQL to get user group and max date. For instance, “select “Default-ReaderGroup” as UserGroup, max(txnDate) as maxDate from table1”
  3. Add dataset into your dashboard
  4. Setup dynamic default parameter value “maxDate” for “Default-ReaderGroup”
  5. Show the parameter value in visual’s title.
2 Likes
3

Roy’s solution works great if you need to use the maximum date in your data set. If your use case is a bit simpler and you just need to show the current date, or yesterday, or some sort of date relative to today, you can use the new Rolling Defaults on date parameters.

image
image584×713 34.9 KB

image
image1248×531 40.2 KB

The product team is also looking into allowing you to set the rolling date equal to the max date from a date column, but I do not have any estimates I can share with you.

3 Likes
4

Hi @Jesse ,
How do i change the format of this date parameter. I am using this exact solution but i cant seem to change the date format.

What i have tried :
formatDate(${currentDate}, 'dd-MM-YYYY')

and it doesn’t work, the text just display exactly my shortcode as above.

5

Hi @LeonardLai , if you want to apply a customer format to the date parameter, you will need to display the parameter in an Insight and overlay it on top of your other visual. You cannot use formulas/functions within text boxes quite yet. The formula you shared will work as-is in an Insight though.

1 Like
6

Hi @LeonardLai Did Jesse’s solution help. Hope so. If it did, can you help the QuickSight Community out by marking his reply as “Solution”? Thanks!

7

Is there any idea when the use of formulas/ calculated fields will be available to use in text boxes? I find it a massive hinderance to how I’m able to display what I need in the title.
I’ve added the relative date but it doesn’t look good without the formatting.
Adding an insight doesn’t work for me, because the field I’m adding isn’t included in the report other than for the filter.

feature-request calculations visuals navigation-and-user-experience

1 Like
8

Thanks @AdamB

We have tagged this as a feature request. At AWS, our roadmap is primarily driven by our customers. Unfortunately, we are unable to provide details on roadmap of feature release dates. Thank you for sharing your feedback, as it helps us build a better service.

1 Like