Displaying the Latest Date in Dashboards: A Step-by-Step Guide

To show the latest date in a dataset, you can follow these steps to create an expression column and display it in the desired format.

Steps to Achieve the Requirement

1. Create an Expression Column
   Use the MAX function to create an expression column that retrieves the latest date from your column. The syntax is as follows:

   MAX(DateColumn)
   

2. Format the Date
   To display the date in the DD/MM/YYYY format, use the appropriate expression based on your source server:

   • For SQL Server:

     CONVERT(varchar(10), [datevalue], 103)
     

   • For PostgreSQL:

     to_char([datevalue], 'DD/MM/YYYY')
     

     

3. Display the Date in a Text Widget
   In the text widget, use the createt expression column in the Label parameter. The syntax is as follows:

   {{:Expression_name}}
   

   
   
   When you preview the dashboard, the date value will be displayed in the specified format.
   

Additional References

• SQL Server Documentation For Convert
• PostgreSQL To Char function