Using a limitation on dimension

[Anonymous]

I am building my report to display data that I want to limit using a variable field.

I have a start date field that I only want reported if the date is more than 18 months ago. in effect it will report all historic sales agents that have not made a sale in a long time or never made a sale at all.

Is it possible to have calculated data as a limitation?

I am trying to use the calculated value as: date(today()-495,'DD-MM-YYYY')

[shraddha_g · Accepted solution]

Load *

From Source

Where DateField >= Date(Today()-495,'DD-MM-YYYY')

(DateField Format should match with calculated Date)

[Anonymous]

Is there no way that this can be achieved on the criteria for the selection in the table that I am trying to produce?

The results are going into a flat table instead of something that is graphically displayed to allow our staff the ability to see if there are sales agents who either have not made a sale or the date of the last sale was greater than the time required.

[shraddha_g]

you can use it in set analysis.

Please provide some sample data and expected output

[Anonymous]

I have used a custom script to load the dates and filter the data to what I want with your help above, however, it is duplicating rows on my table.

I know the cause, it's an incomplete sale that was never really begun so the data started is missing.

I am trying to remove it using the following but it returns no data:

IF($(NoSaleCheck)='Sales',MaxSaleDate,NULL)

Edit:

Managed to figure it out, the IF criteria was wrong and should have been:

IF(NoSaleCheck='Sales',Date(MaxSaleDate),NULL())

thank you for your help shraddha.g

[shraddha_g]

Glad it helped!