Limit Data using Expression on Date

[Youyang Zhang]

I am trying to limit the table visualization on only the latest date of the filtered values. And when no filters are selected, the latest date is displayed.

I want my table to be on The Max([Date]) of my data. I've added [Date]=Max([Date]) on the Data limiting of my table but that's not working when I change the filter date value to be some earlier date.

My datatable looks like this:

 

 

 

Category

Date

Value

 

 

 

 

Category1

1/10/2020

10

 

 

Category1

1/9/2020

9

 

 

Category2

1/10/2020

8

 

 

Category2

1/9/2020

7

 

 

 

I want to create a table Viz that is only showing the latest date, and when the date filter changed to 1/9/2020, it can display the 1/9/2020 values for Category1 and Catetory2.

[Ajinkya Gutti]

In the settings of the table visualtization, you can select what data will be used to display.

There you can mention the filter you are using, so that table can show only based on the selected filter.

Make sure the filter you are marking on and the data filter for the visualization is the same.