If condition with group by

[rakeshkumar1890]

Hi folks,

I am using below aggr code in dimension and working fine but its taking lot of time to populate report.

=Aggr(If([Request Delivery Date] = Request_Delivery_Date,'Match', 'Not Match'),Sapsoli,[Request Delivery Date],Request_Delivery_Date)

I have only one table with above fields.

Is there a way to write above code in script?

[marcus_sommer · Accepted solution]

With the given information it's not possible to say if it could be solved within the script - but it could be surely optimized, for example by something like this:

-(Date1 = Date2) as DateFlag

or

Date1 - Date2 as DateOffset

which might replace your condition/dimensions or applied in another way and/or the further dimension Sapsoli is also evaluated in this context.