Using text filter

[malak rihaili]

Hello everyone,

i wanted to ask how to do a text filter that shows the data for the last one year from the date chosen

like if I entered Jun 2019 it will show the data from Jun 2018 to Jun 2019

your help is appreciated:)

[Gaia Paolini]

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]))

[malak rihaili]

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 ;)