Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
If this is reloading nightly i would do this in script.
If(Date > Today(),1, 0) As FutureFlag,
Mark
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
This is awesome. Thank you both.