topic Re: Using a limitation on dimension in App Development

Using a limitation on dimension

Anonymous — Thu, 30 Nov 2017 12:01:43 GMT

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')

Re: Using a limitation on dimension

shraddha_g — Fri, 01 Dec 2017 04:09:03 GMT

Load *

From Source

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

(DateField Format should match with calculated Date)

Re: Using a limitation on dimension

Anonymous — Mon, 04 Dec 2017 11:50:46 GMT

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.

Re: Using a limitation on dimension

shraddha_g — Mon, 04 Dec 2017 11:56:43 GMT

you can use it in set analysis.

Please provide some sample data and expected output

Re: Using a limitation on dimension

Anonymous — Mon, 04 Dec 2017 12:33:10 GMT

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

Re: Using a limitation on dimension

shraddha_g — Mon, 04 Dec 2017 14:13:24 GMT

Glad it helped!