Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart where the only dimension is the date of a credit return. I'm having the table sort descending by date, which is working fine, the returns are listed in reverse chronological order.
There are a lot of records though, and sometimes it might only be appropriate to show records from the last n days.
In the attached QVW, you'll see that the chart goes back to records made in 2006. How can I limit the date dimension using a length of time? I.E. the last 7 days?
Hi
Check the attached one
Hi,
I think this is what you are looking for
find the attachment
Hi, thanks this worked. Could you explain how the expression makes this work? Is that just a short-hand if statement?
Thanks.
This is because of setanalysis
This is just like Sql query with where clause