# How to display a date range in a footnote at the bottom of report? **URL:** \ **Category:** Q&A\ **Tags:** calculations, quick-sight\ **Created:** [September 12, 2023, 5:35pm UTC](https://community.amazonquick.com/t/how-to-display-a-date-range-in-a-footnote-at-the-bottom-of-report/17952 "2023-09-12T17:35:56Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![kbixler](https://avatars.discourse-cdn.com/v4/letter/k/97f17d/32.png) [@kbixler](https://community.amazonquick.com/u/kbixler)\ **Post date:** [September 12, 2023, 5:35pm UTC](https://community.amazonquick.com/t/how-to-display-a-date-range-in-a-footnote-at-the-bottom-of-report/17952/1 "2023-09-12T17:35:57Z")
I have a dataset with two columns: data\_source & data\_date. These show the date that we last received data from for those particular data sources. There are many data\_sources: | data\_source | data\_date | | --- | --- | | Source A | Sep 8, 2023 | | Source B | Aug 25, 2023 | | Source C | Sep 1, 2023 | | Source D | Aug 18, 2023 | I have a requirement that the data\_dates for two particular data sources show up in a text footnote at the bottom of a tab below all of the other visualizations. It can’t be a table, it has to be a text footnote with specific wording from the legal department that looks something like this: “Lots of other text. Source: Source A as of Sep 8, 2023; Source B 26 weeks ending Aug 25, 2023. Some more text.” In the context of this report, I know that Source A will always be the maximum value and Source B will always be the minimum of the two. I’ve tried using different variations of custom narratives, but I’m not having much luck. I’ve put my data\_date column in the Time field well, and have left both the Values and Categories wells empty. Specifically, the Minimum.timeValue.formattedValue computation goes wrong when I add a filter on the dataset so that it only includes Source A and Source B. When I do that I get the Sep 8 date for both min and max The source text for the narrative that almost works is: “Sources: Source A as of Maximum.timeValue.formattedValue; Source B 26 weeks ending Minimum.timeValue.formattedValue.” What I’m trying to do is similar to the answer to this question, but I want both max and min values: > [@Display Max(date) in a Text Box or KPI](https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431): > > I’m new to QS and this seems like it should be simple, but I can’t figure it out. So I have a column that has the TimeStamp the data was loaded into the snowflake warehouse my spice dataset loads from. I want to display a box at the top of my sheet that says “Data is current as of MM/DD/YYYY” where MM/DD/YYYY is the most recent date in the data set. I have a calculated field for Max Load Timestamp. It works in a Table view. But is there a place where I can put that in elsewhere? like in a KP… As a work around, I thought about using a plain text box and parameters, but it’s unclear to me how I would get the min and max dates from my dataset into parameters. Any tips on accomplishing the above by either using a custom narrative or a parameters with a text box would be much appreciated. ---
**Author:** ![apjvinod](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@apjvinod](https://community.amazonquick.com/u/apjvinod)\ **Post date:** [September 13, 2023, 4:50am UTC](https://community.amazonquick.com/t/how-to-display-a-date-range-in-a-footnote-at-the-bottom-of-report/17952/2 "2023-09-13T04:50:56Z")
Hi @kbixler Thanks for joining Quick Sight community and posting questions. In-order to effectively use Max & Min computation in the Insight Visual we need a measure to do the computation . I have included additional column in the dataset to capture the “data\_date” in a integer format and use it as Measure/value in the Insight Visual. (Include the hour/minute/second format if required) ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2419696605e28a2270c39280150ceee5ab3d5e92.png) Include date-integer field as values in the Insights visual and change the aggregation to Min/Max ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/1/1559259e5beb380a537cdd6878a39be6cb912548.png) And create Min / Max computation in the Insights and include formatted value to display . ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b75b11285dbe30d864e507c81de83f20c38f1592.png) Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. ---
**Author:** ![kbixler](https://avatars.discourse-cdn.com/v4/letter/k/97f17d/32.png) [@kbixler](https://community.amazonquick.com/u/kbixler)\ **Post date:** [September 13, 2023, 1:03pm UTC](https://community.amazonquick.com/t/how-to-display-a-date-range-in-a-footnote-at-the-bottom-of-report/17952/3 "2023-09-13T13:03:26Z")
That works! I had to slightly modify the calculated field because SPICE didn’t like the date format: `parseInt(left(formatDate({data_date},"yyyyMMdd'T'HHmmss"),8))`