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

Using text filter


malak rihaili

Recommended Posts

I am not sure what you mean by text filter, but you could

1) define your start date as document property say ${mindate} of type Date

2) use 'Limit data using expression' in the Data tab of your visualization properties, using this expression:

Integer(DateDiff('day',DocumentProperty("mindate"),[YourDate])) >=0 and

Integer(DateDiff('day',DateAdd('year',1,DocumentProperty("mindate")),[YourDate]))

Link to comment
Share on other sites

thank you for your respoonse,

 

and by text filter I meant that the user can choose the date and then the data displayed will be for the last one year

 

so in the filters panel there will be a filter for thedate and when I type 1/8/2016 for example, it will show all the data from 1/8/2015 to 1/8/2016

 

hope I'm clear ;)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...