Filtering for dates greater than today

[#1]

Hi All,

I'm trying to build a dashboard to monitor credit control. I have transactions with historical dates but also transactions with future dates. what I want to do is create a filter that allows me to filter just to transactions that have a date in the future. Can anyone help?

Thanks,

Jas

[alexandros17]

You can achieve this in the script or in the front end:

in the script when you load data (with load or select) set the where condition as:

Load

....

where myTransDate >= Today()

In the front end use the Trans. date as dimension and write (calculaterd dimension):

If(MyTransDate >= Today(), myTransDate, Null()) and check the box "Suppress when value is null"

Let me know

[#3]

Thanks, sorry, I should have been clearer, within the dashboard I would still like to see historical payments but want to be able to highlight which payments have been received and which remain outstanding and have the ability to filter between the 2.

Thanks

[Mark_Little]

Hi,

If this is reloading nightly i would do this in script.

     If(Date > Today(),1, 0) As FutureFlag,

Mark

[alexandros17]

When you load data you can add a field, something like:

load

...

If(myDate > today, 1, 0) as flagPeriod

....

Then you can use the flag into a multibox or a dimension to filter old and future values

[#6]

This is awesome. Thank you both.