Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Limit Data using Expression on Date


Youyang Zhang

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

×
×
  • Create New...