topic Date Filter in Connectivity & Data Prep

Date Filter

marthajesicap — Mon, 31 May 2021 03:17:13 GMT

Hi,

so, i have a data with date. i want to show the date i filtered in text and image chart.

For example, i have a data from May 1st until May 31st.

I filtered May 22nd and i want to tell people that data that i filtered is May 22nd.

i currently write it manually in text and image chart because i dont know how to script it.

i attach a screenshot of the example.

Thanks for the help

kaushiknsolanki — Mon, 31 May 2021 06:02:44 GMT

HI,

You can use the below expression in the Text object.

Date(Max(Date),'MMM, DD YYYY')

marthajesicap — Mon, 31 May 2021 06:22:06 GMT

thank you for replying.

i have try the expression, but it is only show the latest date not the currently date i choose in the filter.

as the picture i attached, the date in the text is the date that i choose from date filter.

Thank you.

kaushiknsolanki — Mon, 31 May 2021 07:04:00 GMT

In the expression I gave, change the "Date" field to the date field name in which you make the selection and it will work.

NitinK7 — Mon, 31 May 2021 13:27:40 GMT

try below expression.

GetFieldSelections(date)

marthajesicap — Thu, 03 Jun 2021 01:46:52 GMT

it works. Thank you !

marthajesicap — Thu, 03 Jun 2021 01:47:14 GMT

thank you for replying 🙂