To show the latest data availbel date

Question & Answer
1

Hello everyone, I have created a dashboard and it has date wise KPIs. Database is getting updated regularly with the date field.
My question is, how can I show the latest data avilable date when user opens the dashboard from the browser.

Apprecite anybody can suggest a method.

Thanks.

2

Hi,

Just create an Insight visual to show the MAX value of the Date field. Add this visual to your dashboard

3

Thanks for the reply. My date field is in timestamp format. Can you please let me know how do I get the max date.
Thanks.

4

Hi @PandaDH

in the analysis you can reformat the datetime into date with

formatDate(orderDate, 'dd MMM yyyy')

so you can use:

format ( maxOver( Date, , PRE_FILTER ) , ‘dd MMM yyyy’)

I hope it helps,
GL

1 Like
5

Thanks @gillepa it worked.

1 Like