Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member

The point of this article is to provide a method to a value associated with the most recent data in a date selection.


Step 1: in the Elasticube, create a field transforming the date field into an integer using the formula below. Then rebuild the Elasticube (schema changes).

getyear([Date Field])*10000+getmonth([Date Field])*100+getday([Date Field])

Step 2: In the dashboard, create a new pivot table. Set the Dimensions to be the field you want to see the value for the most recent date in and the date field. Set the measures to be the sum of the field you want to see the most recent value of and the max of the date integer.


In the example above, the we want to see the number of clicks on the most recent date for each campaign. 

Step 3: Create a filter on the Max Date Integer to see the the top ranked max date. This will return the values for the most recent date. 


Step 4: Remove the Max Date Measure, you will be left with a table of the Dimension, the max date, and the value for that day.




Version history
Last update:
‎10-19-2021 03:12 PM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: