Skip to Content

Can I use a WHERE clause in dimension as report filter?

I am creating a report that includes many tables, one of them needs to show records that have not been modified in the past 90 days, I would like to use the following formula but It turns the field to null instead of hide it and adding a not null filter does not work neither.
=[Opportunity] Where ([LastUpdate]<RelativeDate(CurrentDate();-90))
A normal filter with a static date works but I want to use a relative date so I do not need to change it every day.
I notice that the problem start when I add fields like region or dates to the table, but I do need them. I have other fields in the table that do not affect the results.

I appreciate any help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 21, 2018 at 04:47 PM

    try to create variable with if-else condition.

    Show/Hide=if([LastUpdate]<RelativeDate(CurrentDate();-90)) then "Show" else "Hide"

    Filter on Show/Hide variable where equal to value "Show"

    Add comment
    10|10000 characters needed characters exceeded